Forum Discussion
dax switch
Hello,
I would like to create a measure to workout the amount based on a currency as follows
Converted value =
switch(
selectedvalue('Currency'[Code] = "GBP", valueMeasure * ColumnRateGBP
,selectedvalue('Currency'[Code] = "USD", valueMeasure * ColumnRateUSD
)
I do not seem to be able to get to ColumnRateGBP value as the dax code complains about it. It is a column in model.
Any suggestions please?
Thank you
3 Replies
- parry2k
Super User
Anonymous are you adding as a column or measure ? Can you share sample data?
- parry2k
Anonymous but you are not using any aggregation. 2nd part of my question was to share sample data.
To get help, you need to provide more information. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
