March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all. I see so many issues with the matrix incorrectly calculating values, now it's my turn to add my problem to the group.
when i calculate month to month % it works fine.
But when I attempt to calculate by Quarter over Quarter or Year over Year, incorrect Results.
My example below illustrates this.
For example, here is the matrix of one record
390/39 of course is not = to 1009.40
Switching it from matrix to table doesn't change the %
How do i resolve this so that the % are correctly calculating? Any ideas?
Always appreciate help.
Thanks, Steven Taub.
So it looks like the error is some how occuring before the data is actually posted into the visual. Rounding errors maybe?
Do you have any suggestions for me on resolving this?
Thanks...
Solved! Go to Solution.
Hey @StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
Actually, I was able to complete this task and I figured out what i was doing wrong.
I was incorrectly identifying a measure that wasn't matching the Month Quarter and Year and I resolved it.
Thanks!
Hey @StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |