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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AndradeRobson
Helper II
Helper II

Calculate formula by term

Dear, good afternoon!

 

I need some help with the DAX formula.

 

I have a formula that already calculates correctly every month, but I need this formula to be divided in two ways, being:

 

The current formula calculates until 09/2022 and the new one I created ignore the previous one and start considering from 10/2022 onwards the new formula for the next few months.

 

Just adding the need. I thought of a formula with the "IF", Example: IF d'calenadario is smaller 30/09/2022 will use formula A, otherwise it will use formula B. Something like that.

 

Could someone help me assemble this formula?

 

Please.

 

Att.

 

Robson

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @AndradeRobson ,

 

Use selectedvalue() to wrap the date column.

Measure C = IF(selectedvalue(calendar[date])<=date(2022,9,30),[Measure A],[Measure B])

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @AndradeRobson ,

 

Use selectedvalue() to wrap the date column.

Measure C = IF(selectedvalue(calendar[date])<=date(2022,9,30),[Measure A],[Measure B])

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
v-jayw-msft
Community Support
Community Support

Hi @AndradeRobson ,

 

Measure C = IF(calendar[date]<=date(2022,9,30),[Measure A],[Measure B])

 

IF I misunderstood your meaning, please share some sample data and expected result.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Good evening!

 

Thanks for the feedback.

 

The function you sent I just didn't understand this calendar[date] field, because when I put IF it doesn't call dcalendario.

 

I'll put more details, being:

 

I have two formulas in dax, one to calculate data up to 09/30/2022 and another current formula to calculate from 10/01/2022.

 

I need a function that when created can apply these two variables

Example of the forms I have:

 

40_Difereca_Horas_=

"This calculation from 01/10/2022 onwards"
var current_function = CALCULATE([07_Difference_Horas_Contradas_Segurança])

 

"This calculates to 30/09/2022

var previous_function =
CALCULATE([24_Difference_Hours_Security])

 

Att.

 

Robson

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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