Forum Discussion

Peter_Yaacoub's avatar
Peter_Yaacoub
Frequent Visitor
4 years ago
Solved

MTD Measure displays no values

Hello everyone! Back with another issue in my measures.   I am trying to caluclate MTD ratios from YTD values using the following formula  MTD Hist Gross Profit = CALCULATE(SUMX(Historical___UK,...
Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Peter_Yaacoub ,

    According to your snapshot, Gross Profit is a column in your table, try to modify the formula to:

    MTD Hist Gross Profit =
CALCULATE ( SUM ( [Gross Profit] ), DATESMTD ( Dim_Dates[Date] ) )

    Best Regards,
    Community Support Team _ kalyj

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

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Peter_Yaacoub ,

According to your snapshot, Gross Profit is a column in your table, try to modify the formula to:

MTD Hist Gross Profit =
CALCULATE ( SUM ( [Gross Profit] ), DATESMTD ( Dim_Dates[Date] ) )

Best Regards,
Community Support Team _ kalyj

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