Forum Discussion

lab's avatar
lab
Frequent Visitor
4 years ago

Completing a rollforward in Power BI

I'd like to create a roll forward of headcount data .  My data is in this format     Function Date Hire1 A Jan Leaver1 B Feb Hire2 C March Hire3 D June Leaver2 E July ...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
4 years ago

lab 
Calculate(sum(value),Filter(allselected(Datesdim),datesdim[Date]>=min(datesdim[date]))
Try this and let me know, but you must have a date table