cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## DAX formula to use if you will get the same value from other field

Hello!

I need help what DAX formula to use if I will get the value of the Cost Recog field with the same value as with the actual Cost. Please see table below.

What I need is the Cost Recog value and this is the same value as with Actual Cost

 Project Actual Cost Cost Recog Project 1 \$2,534,248.23 \$2,534,248.23 Project 2 \$1,633,649.00 \$1,633,649.00

Thank you.

1 ACCEPTED SOLUTION
Super User

@juhoneyighot Maybe:

``````Measure =
VAR __Actual = SUM('Table'[Actual Cost'])
VAR __CostRecog = SUM('Table'[Cost Recog])
VAR __Result = IF( __Actual = __CostRecog, __CostRecog, BLANK() )
RETURN
__Result``````

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Super User

@juhoneyighot Maybe:

``````Measure =
VAR __Actual = SUM('Table'[Actual Cost'])
VAR __CostRecog = SUM('Table'[Cost Recog])
VAR __Result = IF( __Actual = __CostRecog, __CostRecog, BLANK() )
RETURN
__Result``````

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...