DAX

[prashantg364]

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

[v-hashadapu]

Hi @prashantg364 , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @DanieleUgoCopp  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you @DanieleUgoCopp  for your valuable response.

[cengizhanarslan]

You could use a measure as below:

Delta =
CALCULATE ( [Amount], 'YourColumn'[Type] = "Post" )
    - CALCULATE ( [Amount], 'YourColumn'[Type] = "Pre" )

[DanieleUgoCopp]

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