Forum Discussion
Beginning Balance Rollforward
Hello Team - I have a requirement to show "Beginning Balance" Roll forward in a Power BI visual. Given below the sample data and expected output. Can you help me if this is achievable in Power BI? R...
Hello DataNinja777 - Thanks for the detailed steps. I will work on this and get back to you.
I just tried this. It created table from 2023 only. Does this scan my dataset and creates the entries by scanning all date columns in all datasets in my PBIX file?
Calendar =
ADDCOLUMNS (
CALENDARAUTO(),
"Year", YEAR ( [Date] ),
"Month", FORMAT ( [Date], "mmm" ),
"MonthNumber", MONTH ( [Date] )
)
Thanks,
Phani
Does this scan my dataset and creates the entries by scanning all date columns in all datasets in my PBIX file?Yes, yes it does. One of the reasons not to use CALENDARAUTO()