MAX DAY PER MONTH WITH A CONDITIONAL

[CESARPULIDOGDL]

Hi

Thanks for read me, i have a trouble, i need a add a column, that shows the max of the workday (column b) by month, but also have t condition working (columE).

thanks

[CESARPULIDOGDL]

@FreemanZ  thank you, its works..

[FreemanZ · Accepted solution]

hi @CESARPULIDOGDL 

try like:

Column = 
MAXX(
    FILTER(
        TableName,
        FORMAT(TableName[Fecha], "yyyymm")=FORMAT(EARLIER(TableName[Fecha]), "yyyymm")
        &&TableName[IsWorkingday]="working"
    ),
    DAY(TableName[Fecha])
)

or

Column2 = 
MAXX(
    FILTER(
        TableName,
        EOMONTH(TableName[Fecha],0)=EOMONTH(EARLIER(TableName[Fecha]),0)
        &&TableName[IsWorkingday]="working"
    ),
    DAY(TableName[Fecha])
)

it makes more sense to do with a measure.