Forum Discussion

Hippocampus's avatar
Hippocampus
Frequent Visitor
3 years ago

Roll-up view

Hi all. I would like a roll up view like below: 

Now I have written this dax script: 

 

RollupTable = 
    SUMMARIZE (
        costprice_history,
        ROLLUP (
            dimdate[FiscalYear],
            dimdate[CalendarQuarterNumber],
            dimdate[CalendarWeekNumber],
            dimdate[DateKey]
        ),
    "RowCount", COUNTROWS (costprice_history)

 

The output of the visualize matrix is like this:  

 

I would appreciate any help on how to achieve the roll up view that i posted.
Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Hippocampus 

     

    Is this the result you expect?

    Please check the attachment.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.