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

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