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]))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit,

i need only last date value for each month. MTD it's making sum of entire month 

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous,

with EOMONTH you can determine the last date of a month.

https://dax.guide/eomonth/

 

 

EOM Sales = CALCULATE(SUM(Sales[Sales Amount]), 'Date'[Date] = EOMONTH(MAX('Date'[Date]), 0))

 

 

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

    Hi mwegener ,

     

    Thanks for the update but how to get previous last day value ? and previous month value as well ?

    please give me dax for previous month last day ?

     

    Thanks