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.
I have seen the new preview feature for dynamic formatting and though I'd give it a go formating a duration measure (hours) into the format years,days,hours using the following formatting dax:
However, this is sometime returning incorrect values.
Not sure if i am doing something wrong, or it is just a bug with the new feature. Has anyone else managed to format a time duration measure into an easily readable format?
Solved! Go to Solution.
I figured out the issue. If your output string contains a 0, then it is substituted out for the measure value.
You can work around this with the SUBSTITUTE function.
So new solution:
I figured out the issue. If your output string contains a 0, then it is substituted out for the measure value.
You can work around this with the SUBSTITUTE function.
So new solution:
User | Count |
---|---|
81 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |