Forum Discussion

AndradeRobson's avatar
AndradeRobson
Helper II
3 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AndradeRobson ,

     

    Use selectedvalue() to wrap the date column.

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

AndradeRobson's avatar
AndradeRobson
Helper II
3 years ago

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