Forum Discussion

RekhaG's avatar
RekhaG
Frequent Visitor
7 years ago

PowerBI -MDX Cube - YTD

Hi,   I have a Power BI Report where the data points are month-year(from date dimension) and a YTD measure.   The source is a multi-dimensional SSAS cube. The YTD Measure and month-year are taken...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi RekhaG,

 

Create a TOTALYTD to workaround.

 

Measure = TOTALYTD(SUM(Table1[sales]),Table1[date])

 

 

For more details, please check the pbix as attached.

 

Regards,

Frank

RekhaG's avatar
RekhaG
Frequent Visitor
7 years ago

Thank you for your response v-frfei-msft.

 

I am using a multi dimensional cube as the source for my report. I cannot use TOTALYTD(DAX) on it.

  • ChristianM83's avatar
    ChristianM83
    New Member
    6 years ago

    Have you found the solution ?