Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
How to write DAX measure to calculate sales for previous day and last month previous day in DAX. Suppose today is April 13 so i would require sales for April 12 and March 12. How to do it? Thanks in advance
Solved! Go to Solution.
@MeghnaZutshi , if you need based on today and there is no date filter
previous day = calculate([net], filter(table, Table[Date] = today()-1) )
previous month day =
var _last = date(year(today()), month(today()) -1, day(today()) )
return
calculate([net], filter(table, Table[Date] = _last ) )
or with the date table ignoring the filter on date table
previous day = calculate([net], filter(all(date), date[Date] = today()-1) )
same way other more such formula
@MeghnaZutshi , if you need based on today and there is no date filter
previous day = calculate([net], filter(table, Table[Date] = today()-1) )
previous month day =
var _last = date(year(today()), month(today()) -1, day(today()) )
return
calculate([net], filter(table, Table[Date] = _last ) )
or with the date table ignoring the filter on date table
previous day = calculate([net], filter(all(date), date[Date] = today()-1) )
same way other more such formula
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |