Forum Discussion
Solved
Problem creating a DAX query
Hi, I'm really struggling to get the syntax right on this DAX query I'm writing and I can't seem to find a solution that fits online. I have two tables. Dwh_Fact_Main and Nominal_Info. Fa...
@tom_cowling - Try wrapping column references in something like MAX
Hello a serious choice like this
given
var ing = CALCULATE( [ValorDetalle] , 'Nominal'[Nominal] =1000)
var gast = CALCULATE( [ValorDetalle]*-1 , 'Nominal'[Nominal] =1100)
var pers = CALCULATE( [ValorDetalle]*-1 , 'Nominal'[Nominal] =1200)
return
ing+gast+pers
-------------------------------
data model
------------------------------
Result
