topic How create a list in dax in DAX Commands and Tips

How create a list in dax

Anonymous — Wed, 15 Mar 2023 17:55:30 GMT

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.

Re: How create a list in dax

amitchandak — Wed, 15 Mar 2023 18:14:55 GMT

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

Re: How create a list in dax

Anonymous — Wed, 15 Mar 2023 18:26:12 GMT

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!