Forum Discussion
Create dynamic calculated matrix - DAX
Hi all. I am trying to migrate over from excel based solutions to Power BI. So far I am good with the M Code in Power Query but I am struggling a touch with the DAX - hoping for some help as don't ...
v-xiaotang
Community Support
Community SupportHi nialls_pbi
Thanks for reaching out to us.
The fomula for CAD is =ROUND(B2/SUMIF($A:$A,C$1,$B:$B),6), it uses the value of column B (AUD), but how to calculate AUD?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi there.
Thanks for reading my post. Apologies for not making it clear!
The cells in green (AUD vs CAD, EUR, CHF, DKK, etc.) are received daily - we have this data. So for the calcs we have 1/0.9128 = 1.09553 (AUDvsAUD/AUDvsCAD = CADvsAUD). Same way AUDvsDKK/AUDvsEUR=EURvsDKK or 4.697/0.6317=7.435492 or B6/B7.
I hope this makes sense.
Thanks again.
Niall.