Forum Discussion
Help on converting excel formula to DAX
Experts,
Need help on below excel formula converting to Dax
| Data and Lookup tables | Calculated fields | |||||||||||
| Nov, 2019 | Aug'19 AR | |||||||||||
| a | b | c | d | e | f | g | h | i | j | |||
| HW | EUR | 65.4 | 76.1 | 72.3 | 1.1132 | 80.5 | 90% | 1.1633 | 6.9 | 7.7 | 1.159 | |
| MXN | 118.6 | 6.1 | 336.2 | 18.98 | 17.7 | 35% | 19.5611 | 217.6 | 11.5 | 19.18 | ||
E =IF(ISERROR($G6*$F6),"",IF(OR($C6="EUR",$C6="GBP",$C6="NZD",$C6="AUD"),$G6*$F6,$G6/$F6))
J= =IF(ISERROR((E6+M6)/F6),"",IF(OR($C6="EUR",$C6="GBP",$C6="NZD",$C6="AUD"),(E6+M6)/F6,(1/((E6+M6)/F6))))
I need this two quick help much appreciated
Thanks
4 Replies
- sturlaws
Resident Rockstar
Hm, perhaps you could upload a sample excel-file to onedrive or something similar, and provde a link to it here. I can't figure out what you are trying to do from what you have posted.
cheer,
S
Thanks for replay.
Here is the link
https://drive.google.com/open?id=1wrWrb7Nk8iOxdGsL2L6cLnq6nngXU0wY
Please let me know if you have any question. Excel attached with data and calculation in the same page.
Thanks