Total business days per month

[Joshua_]

hi guys,

I need to add a column based on the maximum value of day_habil_mes of each month. 
I'm working with Date Table.

thank a lot !!!

regards

[Ashish_Mathur]

Hi,

Try this calculated column formula

=calculate(max(dia_habil_mes),filter(data,data[period]=earlier(data[period])))

Hope this helps.

[jdbuchanan71 · Accepted solution]

@Joshua_ 

Give this a try.

max Day per month =
CALCULATE ( MAX ( Dai_Habil_mes ), ALLEXCEPT ( 'Dates', 'Dates'[Period] ) )

[Joshua_]

its works.

thank @jdbuchanan71