Forum Discussion

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

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

4 Replies

vigneshahob
Frequent Visitor
4 years ago
You will have to decide if this should be a column or a measure.

Measure would aggregate and so the filter context plays a key role.

If you would like every row to be flagged "Visually", then you will have to create a column not a measure.
- Anonymous
  Not applicable
  4 years ago
  I am planning to create a calculate column but its not working
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?

Icon for Community Support rank

Community Support

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

Related content