It's written for Excel, but Power BI has the same functionality, just different looking buttons, so see this post for what it looks like in Power BI, but Mynda in the link above explains things really you pivot the data then your column to column calculations will NOT update automatically - you will need to redefine the calculations each month to include the new month's data. If you leave the date values in a single column, then you can use DAX Time INtelligence measures to calculate the differences between Years, Quarters, etc.Ī date table can make quarters, year to date, etc comparisons easier, then use functions like TOTALYTD, DATEADD, etc:įor updating your report with new Excel file each month, see if this helps:
You pivot the data then your column to column calculations will NOT update automatically - you will need to redefine the calculations each month to include the new month's data.
0 kommentar(er)
