DAX script for measure based on date dimention
In SSAS I have the fact table:
DAX script for measure based on date dimention
In SSAS I have the fact table:
Measure DAX formula with SWITCH
I want to create a formula for a measure that will apply different formulas depending on the FormulaId column in the fact table. But for some reason the line “Table'[FormulaId]” in “var Formula = ‘Table'[FormulaId]” is highlighted in red with a syntax error. This column definitely exists, there is no mistake in the name.
Is it possible to use the value from a table column as the text of a DAX formula for measure?
please tell me, is it possible to use the value from a table column as the text of a DAX formula for measure? In dimention table will store the following values: