Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have a dataset that I am wanting to create the following metrics for:
Metrics:
========================
I have created measures for MTD / QTD and YTD for *this year* and it works fine. When I create it for *last year* I get a blank.
Please help as I have tried changing the format of the data, changed the data model etc.
Kind regards
Arnie.
Solved! Go to Solution.
At the very minimum you need a calendar/dates table. you cannot use your facts table for date math.
Once the dates table is in place, have a look at the "quick measures" templates in Power BI. They include MTD and more. Also check https://daxpatterns.com
Thanks for that, it works 🙂
kind regards
At the very minimum you need a calendar/dates table. you cannot use your facts table for date math.
Once the dates table is in place, have a look at the "quick measures" templates in Power BI. They include MTD and more. Also check https://daxpatterns.com
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
20 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
28 | |
23 | |
22 | |
22 |