Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The source data for my data is already aggregated by quarter and year. There is no date-level detail so I do not have a date table. I need to build YTD total measures for the following:
This is my table:
Can someone help me with the DAX syntax to accomplish this?
I don't think that would help you. Instead, add a calendar table to your data model and use the standard functions.
@lbendlin thank you. I have now figured out the solution. I was confused because when I created a date table before and tried to connect my "Q1 2022" data field to the date table, it would not allow me because it's a many to many relationship.
What I figured out is that I just need to create a date field for all of my Q1 2022 data and set it to 1/1/2022 to connect to the date table. That's the part I was missing!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |