Forum Discussion

Ashish_D's avatar
Ashish_D
Frequent Visitor
4 years ago
Solved

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 20...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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's avatar
Ashish_D
Frequent Visitor
4 years ago

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"