Carry Forward Volumes

[Ashish_D]

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.

[v-chenwuz-msft · Accepted solution]

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.

[Ashish_D]

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]

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" 

[Ashish_D]

it worked , but searching for option which shows total of carry forawrd. example selected lines below

[amitchandak]

@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])))

HR-  https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Ashish_D]

Attached snip for referce showing two date columns

[Ashish_D]

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