Forum Discussion

dakins's avatar
dakins
Icon for Helper II rankHelper II
4 years ago
Solved

Need help converting calculate column to Measure

Hello Friends, How can I convert this calculated column below to a measure?   Sales_Fee = SWITCH(TRUE(), 'Product'[Product_Name] ="Iphone X", "250.00", // 'Product'[Product_Name] ="Iphone R", ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • edhans's avatar
    edhans
    4 years ago

    I still cannot make heads or tails out of the original calculated column DAX with the syntax errors. If you want to use the date from a date table use RELATED('Date'[Date]) instead of the order date. 

    Otherwise read EVERYTHING I wrote in my first post and provide all of that. 

dakins's avatar
dakins
Icon for Helper II rankHelper II
4 years ago

edhansMuch appreciated. I was able to re-create the custom column by replacing order date with RELATED('Date'[Date]).

 

The code I posted in my inital post isn't a DAX code but a custom column code. I was looking to turn the custom column into DAX. Perhaps, it isn't possible. I am new to Power bi and learning its limitations.

 

Thanks again

 

 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
4 years ago

Glad I was able to help with the RELATED() function. A calculated column in Power BI is DAX. So is a Calculated Table, and a Measure. All DAX. 

The only code that isn't DAX is M code in Power Query, but if you are in the data model, it is DAX everywhere.