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.
Hello! I am having difficulty making a dax formula to create a revenue year to date. Attached is the code that I have and tables that I have as well. Thanks in advance!
Dax:
Solved! Go to Solution.
I had this working about a week ago, but it just recently stopped working. I have a column in a table already that's joined properly that has date in it. I shouldn't have to create ANOTHER date table.
So it's coming in and not giving me an error, it's just blank. But I have about 2 million lines of data in my report.
@Anonymous , do not use [Date].Date, In case your date have timestamp, create a new date
New Date = [Date].date
or
New Date = date(year([Date]),month([Date]),day([Date]))
Then join this date with date table and use time intelligence
TOTALYTD([Revenue], 'Date'[Date])
Refer to my Video, Why TI Fails : https://youtu.be/OBf0rjpp5Hw
It's not letting me create a measure of a new column in the table for that. I even changed the query to be date instead of a date with a timestamp.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |