Forum Discussion
Solved
Multiple Currencies
Hi All, I am currently building a report for multiple offices (UK and US). Obviously the US Office would like to see all their figures in Dollars. I am using a Cube so the data model is set befor...
SRobbo1990 , if based on userprincipalname if you can get country then you can switch the measure
example
Meausure =
var _cnt = maxx(filter(Table, Table[email] =userprincipalname (), ), Table[Country])
return
Switch(_cnt ,
"USA", [USD Measure],
[GBP Measure]
)
amitchandak
Super User
Super UserSRobbo1990 , if based on userprincipalname if you can get country then you can switch the measure
example
Meausure =
var _cnt = maxx(filter(Table, Table[email] =userprincipalname (), ), Table[Country])
return
Switch(_cnt ,
"USA", [USD Measure],
[GBP Measure]
)