Forum Discussion
Solved
DAX
Table create from a dataset. all column headers are coming from column values rows are DAX measures. i need to create a delta column, post-pre pls suggest
Hello,
try something like calculating Post and Pre separately with CALCULATE filtering that column, then return Post - Pre, basically:Delta =
CALCULATE([your measure], column = "Post") - CALCULATE([your measure], column = "Pre")if that doesn’t work it might be because of how the matrix is built, in that case you could also create a disconnected table for Pre/Post/Delta and handle it with SWITCH
Best regards,
DanieleYou could use a measure as below:
Delta = CALCULATE ( [Amount], 'YourColumn'[Type] = "Post" ) - CALCULATE ( [Amount], 'YourColumn'[Type] = "Pre" )
You could use a measure as below:
Delta =
CALCULATE ( [Amount], 'YourColumn'[Type] = "Post" )
- CALCULATE ( [Amount], 'YourColumn'[Type] = "Pre" )