Forum Discussion
Helper IINeed help converting calculate column to Measure
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.
Community ChampionI 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.
- edhans
Hey dakins - just wanted you to know I am not trying to be difficult. When I tried to understand your DAX code, I use DAX Formatter to format it so I can see what it is doing and where the commas go. This is what I get:
so it is really difficult to get started.
As for the end result, I'd need to know how you are reporting this, because as noted earlier, visuals create filter context and different visuals can apply different filters depending on what you are doing. So the info requested below is really key to getting an answer when it is as complex as yours. This isn't a simple 5 minute answer. There is no "convert calculated column to measure" wizard.
dakinsedhansMuch 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
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.