Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |