Hi everyone,
I am struggling with to create a measure. I need to compute the difference between 2 values in two different columns. I created a calculated column wich serves the purpose but it slows down my model (see below).
Is there some way to use a DAX measure to do the same computing without creating a calculated column ?
Thanks in advance !
Solved! Go to Solution.
@Easy_E
MEASURE = SUMX(Table,Table[Column1] - Table[Column2])
Regarding the SUMX it depends on what you want to show on the total. If it's summing them than SUMX, if it's averaging them than AVERAGEX etc
@Easy_E
MEASURE = SUMX(Table,Table[Column1] - Table[Column2])
Regarding the SUMX it depends on what you want to show on the total. If it's summing them than SUMX, if it's averaging them than AVERAGEX etc
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.