Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How to write DAX query to return previous month? for example Current month is November I want a record for previous Month October? Here is my DAX query
EVALUATE
SUMMARIZECOLUMNS(
Dates[YYYY-MM],
Dates[Mth Year],
\Dates[Default Start Date]
)
ORDER BY
Dates[YYYY-MM] DESC,
Dates[Default Start Date] DESC
Solved! Go to Solution.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |