Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help : based on slicer month selection get previous and current sales values

Hi All, i have seles and target with datewise if i selection month from slicer i need to get each month last date target and sales values (ex: if i select Feb'21 then i should get last year, last mo...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    MSuser5 , In measure use a measure like

     

    lastnonblankvalue('Date'[Date],SUM(Sales[Sales Amount]))

     

    last MTD Sales = CALCULATE(lastnonblankvalue('Date'[Date],SUM(Sales[Sales Amount])),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
    last month Sales = CALCULATE(lastnonblankvalue('Date'[Date],SUM(Sales[Sales Amount])),previousmonth('Date'[Date]))

MSuser5's avatar
MSuser5
Icon for Helper III rankHelper III
4 years ago

amitchandak ,

 

Thanks!
Above mentioned DAX calculating sum of month value but as per requirement i need month last day value same like previous month last day value attached screenshot for ref.

Kindly help me