Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |