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())

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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())