topic MAX DAY PER MONTH WITH A CONDITIONAL in DAX Commands and Tips

MAX DAY PER MONTH WITH A CONDITIONAL

CESARPULIDOGDL — Fri, 14 Apr 2023 04:29:17 GMT

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

Re: MAX DAY PER MONTH WITH A CONDITIONAL

FreemanZ — Fri, 14 Apr 2023 10:40:18 GMT

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.

Re: MAX DAY PER MONTH WITH A CONDITIONAL

CESARPULIDOGDL — Mon, 17 Apr 2023 22:58:31 GMT

FreemanZ thank you, its works..