Help on converting excel formula to DAX

[Anonymous]

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

[sturlaws]

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

[Anonymous]

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

[sturlaws · Accepted solution]

Ok, so this should be solved using calculated columns, and I set it up for you here: pbix

cheers,

-s

[Anonymous]

Thank you so much for your help. Appreciate your time and solution