Forum Discussion
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 before I even open PowerBi.
My question is I have the 'Sum of Booking GBS BCY' which equates to local currency figures and the 'Sum of Booking GBS GBP' needed for the Global Corporate figures both in my data model, I'm wondering would it be possible to filter the report so when I filter by US it only shows 'Sum of Booking GBS BCY' and 'GBP' when filtering by UK?
Thanks
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]
)
1 Reply
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]
)