Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate delta between values in column based on value in another column

Hi,   I have a table that look like this (Table1):   Tag VersionID Value A 1 1,5 B 1 2,1 C 1 4,5 A 2 1,1 B 2 1,4 C 2 2,3 A 3 3,1   And another table t...
CALCULATE
DAX
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok - I finally fixed it by simply creating a new measure and copying my code into this new measure. Now it works - so I guess the error was just a bug.

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

Assuming your model looks something like this

 

then a prop_delta measure like this

 

 

Gives a result like this

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Paul,

     

    thanks for your advice - however this still gives me the "A table of multiple values was supllied where a single value was expected" error.