Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DATEADD Result return blank (Please help)

Hi All   Im currently having an error with DATEADD Dax function, in the middle of the data there is a blank result which I couldnt figure out why.   Dax used: Measure 1 = DATEADD(Sheet1[CAL_CLO...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Dateadd: Returns a table that contains a column of dates

    Please try to use EOMONTH.

     

    Measure 1 = EOMONTH(MAX(Sheet1[Month]),-2)
    Measure =
VAR A = Sheet1[Measure 1]
RETURN
    CALCULATE (
        MAX ( Sheet1[Count CM] ),
        FILTER ( ALL ( Sheet1 ), Sheet1[Month] = A )
    )

     

     

    Best Regards

    Community Support Team _ Polly

     

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Dateadd: Returns a table that contains a column of dates

Please try to use EOMONTH.

 

Measure 1 = EOMONTH(MAX(Sheet1[Month]),-2)
Measure =
VAR A = Sheet1[Measure 1]
RETURN
    CALCULATE (
        MAX ( Sheet1[Count CM] ),
        FILTER ( ALL ( Sheet1 ), Sheet1[Month] = A )
    )

 

 

Best Regards

Community Support Team _ Polly

 

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