Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
TOTALYTD is not giving the result i would expect it to. When i write this measure;
Any tips?
Solved! Go to Solution.
Hey @Anonymous ,
the problem is or was that you don't use a proper date table.
Most of the time intelligence functions work only if you have a date table. I integrated a date table and now it works like a charm:
I will send you the file in private.
Hey @Anonymous ,
can you share your file?
Usually that shouldn't happen.
Best regards
Denis
Long time reader, first time poster... dumb question, but how can I share .pbix?
Hey @Anonymous ,
you have to use an external service like OneDrive or I prefer swisstransfer.com
Best regards
Denis
Hey @Anonymous ,
the problem is or was that you don't use a proper date table.
Most of the time intelligence functions work only if you have a date table. I integrated a date table and now it works like a charm:
I will send you the file in private.
Thank you! I had to change some relationships and measures, but it works when i add the data table and made a few other tweaks. Thanks so much for your help!
Hey @Anonymous ,
I'm happy it works now 😊
Have a great day.
Best regards
Denis
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |