DATEADD from another measure

[Syndicate_Admin]

Hello!

I need to generate a formula that brings me the minimum date of a column, minus 3 months.

Generate a calculated measure to bring back the oldest date (MIN). That's what I wanted to apply a Dateadd to, but since it's not a date table, it doesn't allow me to generate the formula.

Thank you very much from now, I hope you have understood what I am looking for.

Best regards.

[v-yiruan-msft · Accepted solution]

Hi @Verosb ,

You can create a measure as below to get it, please find the details in the attachment.

3 months before Mindate = 
VAR _mindate =
    CALCULATE ( MIN ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
VAR _premonth =
    EOMONTH ( _mindate, -3 )
VAR _minday =
    DAY ( _mindate )
VAR _preday =
    DAY ( _premonth )
RETURN
    IF (
        _minday > _preday,
        _premonth,
        DATE ( YEAR ( _premonth ), MONTH ( _premonth ), DAY ( _mindate ) )
    )

Best Regards

[Shaurya]

Hi @Syndicate_Admin,

You can use:

Min Date Minus 3 Months = DATE(YEAR(MIN('Table'[Date])),MONTH(MIN('Table'[Date]))-3,DAY(MIN('Table'[Date])))

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI