Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hello, I have noticed a very weird results of dynamic formatting and consider this a bug to be fixed.
Zero - just a plain sum of a cloumn that contains number of hours in decimal format (like 3.5)
Fm_Zero - converts it to a more convinient format 3.5 -> 3h:30 with the following dax:
It works just fine for the matrix but if this code is used as a dynamic format string it htrows error if the nymber of hours ends with 0.
This is marked by red and green. It mulitplies the number by ~11 and rounds it.
Also, the axis got an extra "4" in the beginning - but this changes sporadically, it might also divide all the numbers by 10.
Checked with ROUNDDOWN and other similar functions as well as giving dynamic format throough calculation groups - always same result.
What do you think?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.