Forum Discussion

prashantg364's avatar
prashantg364
Helper II
5 months ago
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
Need Help
  • DanieleUgoCopp's avatar
    DanieleUgoCopp
    5 months ago

    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,
    Daniele

  • cengizhanarslan's avatar
    cengizhanarslan
    5 months ago

    You could use a measure as below:

    Delta =
CALCULATE ( [Amount], 'YourColumn'[Type] = "Post" )
    - CALCULATE ( [Amount], 'YourColumn'[Type] = "Pre" )
DanieleUgoCopp's avatar
DanieleUgoCopp
Super User
5 months ago

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,
Daniele