Forum Discussion
Carry Forward Volumes
Hi Ashish_D ,
You can use matrix table in power bi, it is the same as pivot in excel.
Create a matrix visual in Power BI - Power BI | Microsoft Docs
Please share some sample data and expect result, If you need more help.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ashish_D ,
You can use matrix table in power bi, it is the same as pivot in excel.
Create a matrix visual in Power BI - Power BI | Microsoft Docs
Please share some sample data and expect result, If you need more help.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it worked , but searching for option which shows total of carry forawrd. example selected lines below
I am also stuck on another data point. I have shared snip. What i am trying to do get Time worked by adding and substrction teh values example: Time Worked = Staff Complement + flexitime + Overtime - Annual leave - Downtime . trying to create a Measure using "ActivityName" & "TotalTime_Mins"
Hi, The matrix table did help a mbit, but I think power bi does not have abitilty as of now to have expandable columns. Let me know if i am misisng sominthing
