Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
3 years ago

Totalling error in MTD sales

Hi All,   Here is a screenshot of the dashboard which is showing wrong totals :   The total in the MTD column for Feb is wrongly being calculated (the actual number if added from the base f...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

monojchakrab , Is LMSP Value is same as Total Sales ?

 

if yes

Can you share calculation all related measures in tax format

  • monojchakrab's avatar
    monojchakrab
    Icon for Resolver III rankResolver III
    3 years ago

    amitchandak - Amit, as for LMSP, I have tweaked the total sales figure to reflect the last month, which means for Feb, it shows Jan.

    The measures used in dax format as below :

    LMSP Val = 
Var _Maxdate = MAX('Date Table'[Date])
Return
   IF(DAY(_Maxdate)<>DAY(DATE(YEAR(_Maxdate),MONTH(_Maxdate)-1,DAY(_Maxdate))),
   BLANK(),
   CALCULATE(
       TOTALMTD('Measures tray'[Total Sales], DATEADD('Date Table'[Date],-1,MONTH)
    )
    ))
    MTD Val = 
    TOTALMTD('Measures tray'[Total Sales],'Date Table'[Date])

    let me know, if this helps, or if you need something more to work thru' this.

    Thanks for the quick revert