The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.