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 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 |
---|---|
9 | |
8 | |
5 | |
3 | |
1 |
User | Count |
---|---|
18 | |
12 | |
3 | |
2 | |
2 |