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 am trying to multiply two measures.
26.00 and 16.31 and I keep getting just 424.00, when it should be 424.06.
I already tried switching Data types on all measures but it won't change the result.
TIA
Solved! Go to Solution.
@rogerthat Can't replicate it. You might try something like this to make sure you are getting all of your significant digits for your other two measures in the context of the last measure.
'table1'[mesasure] & "," & 'table1'[measure2)
@rogerthat Can you share your formulas?
'table1'[mesasure] * 'table1'[measure2)
@rogerthat Can't replicate it. You might try something like this to make sure you are getting all of your significant digits for your other two measures in the context of the last measure.
'table1'[mesasure] & "," & 'table1'[measure2)
Getting the following, I'm not sure I have the decimal places to two @Greg_Deckler
@rogerthat Confused because those don't seem to match your numbers from before, those would equal 391.9999999992 or essentially 392.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |