Forum Discussion

CESARPULIDOGDL's avatar
CESARPULIDOGDL
Icon for Helper I rankHelper I
3 years ago
Solved

MAX DAY PER MONTH WITH A CONDITIONAL

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

 

 

 

dates
Max
MAXA
MAXX
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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.

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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.