Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How create a list in dax

Hi all, I neew create a dax measure that give me a list with the last available date with data and the last date from last month, also the delta between both, then I will put this in a matrix as c...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , You need measure like these with date tbale and time intelligence

     

    MTD Sales = CALCULATE(lastnonblankvalue(Date[date], SUM(Sales[Sales Amount]) ),DATESMTD('Date'[Date]))
    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]))

     

    Diff= [MTD Sales] -[last month Sales]

     

    Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , You need measure like these with date tbale and time intelligence

 

MTD Sales = CALCULATE(lastnonblankvalue(Date[date], SUM(Sales[Sales Amount]) ),DATESMTD('Date'[Date]))
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]))

 

Diff= [MTD Sales] -[last month Sales]

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much for that!!! You help me a lot, just a quick recap, how can I add these results in a table?

Thank you again!