Forum Discussion
Carry Forward Volumes
Hi,
I have data set which has incoming volume dates (Column name "Assigned Date") from 2019 until end of 2021 & data also has Completed volumes (Column name "Assigned to office") from 2019 until 2021. I trying to figure out how can i know what is the carry forward at the end of each month and display it in Powerbi. I have done it in excel using simple pivot but unable to get it on powerbi.
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.
7 Replies
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
Ashish_D , carry forward not as simple as excel.
You need to create cumulative measures like inventory or HR
example
Inventory / OnHand
[Intial Inventory] + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))Thank you for replying, i am trying to go aroud the formula and the logic, However in my case , the volumes could have come in Jnaury and completed in March. Since this was c/f to Feb and then to March , trying to figure out how to relate the start date with completed date. I want to show that i recieved 1000 volume in Jan , out of whic 900 were compted in jan and 50 in feb and otehr 50 in mar. i.e 100 c/f. same for the feb ,march and so on
Attached snip for referce showing two date columns
