Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to implement DAX formula for this : if column F- column G=column H-column I=True else false

 
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Please try to create a new column like below:

    Match = 
var f1 = 'Table'[PIR Count]-'Table'[PDR Count]
var f2 = 'Table'[GIR Count]-'Table'[GDR Count]
return IF(f1=f2,TRUE(),FALSE())

     

vigneshahob's avatar
vigneshahob
Frequent Visitor
4 years ago

IF ( 'table'preinsert + 'table'gginsert - 'table'predelete - 'table'ggdelete = 0, true, false)

 

If that doesn't work, can you share what error you are seeing?