How create a list in dax

[Anonymous]

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 colunm, like the example in attached. 

[amitchandak · Accepted solution]

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

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!