Skillwave Training @skillwave.training · 29d An student had inherited a #PowerBI file with a #DataModel problem. The budget table used a non-standard date key (not an actual date) so the original dev built a bridge table to link it to the calendar. The result? Budget numbers either showed as grand totals on every row or disappeared to 0. 🧵
0 likes 1 replies
?
Replies
@excelguru.ca's fix was elegantly simple: go back to #PowerQuery for the budget table, convert that YYYYMM integer to a proper date (PQ assumes the 1st of the month automatically), then link it directly to the calendar. No bridge table needed - it and its associated confusion vanished entirely. 😎