DAX Function to Falculate Different Times

[AndradeRobson]

Dear, good afternoon!

Please could you help me I have two formulas in dax, one to calculate data until 30/09/2022 and another current formula to calculate from 01/10/2022.

I'm in need of a variable function that, when created, can apply these applications as I filter the data segmentation.

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 until 30/09/2022

var previous_function =
CALCULATE([24_Difference_Hours_Security])

Att.

Robson

[Anonymous · Accepted solution]

Hi  @AndradeRobson ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Group =
var _date1=DATE(2022,1,10)
var _date2=DATE(2022,9,30)
return
SWITCH(
    TRUE(),
'Table'[Date] >=_date1&&'Table'[Date]<_date2,1,
'Table'[Date]>=_date2,2
,3)

2. Create measure.

Measure =
SUMX(FILTER(ALL('Table'),'Table'[Group]=MAX('Table'[Group])),[Amount])

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly