Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
leerjones85
Frequent Visitor

Help with IF DAX Measure

Hi,

 

I am new to Power BI and have got stuck when creating a measure.

 

I have a fact table the following columns

 

'FACT_METRICS'[DATE]

'FACT_METRICS'[ACTUAL]

'FACT_METRICS'[TARGET]

 

I have a dimension table with the following

 

'DIM_DATE'[DATETIME]

'DIM_DATE'[DAY_MINUS]

 

I am wanting to create a measure than returns the following

 

IF 'FACT_METRICS'[DATE] < 'DIM_DATE'[DATETIME] WHERE 'DIM_DATE'[DAY_MINUS] = "Today" THEN CALCULATE(SUM('FACT_METRICS'[ACTUAL]) - SUM('FACT_METRICS'[TARGET])) ELSE SUM('FACT_METRICS'[TARGET])

 

Any help is much appreciated,

 

Thanks

1 ACCEPTED SOLUTION
shafiz_p
Super User
Super User

Hi @leerjones85 It sounds like you’re trying to create a measure that compares dates and calculates different sums based on the condition. Here’s how you can achieve this in DAX:

To get today's date:

TodayDate = 
CALCULATE(
    MAX('DIM_DATE'[DATETIME]),
    'DIM_DATE'[DAY_MINUS] = "Today"
)

Main measure:

Actual vs Target Measure = 
IF(
    MAX('FACT_METRICS'[DATE]) < [TodayDate],
    CALCULATE(
        SUM('FACT_METRICS'[ACTUAL]) - SUM('FACT_METRICS'[TARGET])
    ),
    SUM('FACT_METRICS'[TARGET])
)

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz

View solution in original post

2 REPLIES 2
leerjones85
Frequent Visitor

Thank You!

shafiz_p
Super User
Super User

Hi @leerjones85 It sounds like you’re trying to create a measure that compares dates and calculates different sums based on the condition. Here’s how you can achieve this in DAX:

To get today's date:

TodayDate = 
CALCULATE(
    MAX('DIM_DATE'[DATETIME]),
    'DIM_DATE'[DAY_MINUS] = "Today"
)

Main measure:

Actual vs Target Measure = 
IF(
    MAX('FACT_METRICS'[DATE]) < [TodayDate],
    CALCULATE(
        SUM('FACT_METRICS'[ACTUAL]) - SUM('FACT_METRICS'[TARGET])
    ),
    SUM('FACT_METRICS'[TARGET])
)

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.