Forum Discussion

PS_78's avatar
PS_78
Icon for Helper II rankHelper II
1 year ago

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...
Need Help
PS_78's avatar
PS_78
Icon for Helper II rankHelper II
1 year ago

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
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()