Home Forums Power Pivot Adding Days in a Measure

This topic contains 0 replies, has 1 voice, and was last updated by  lilzenbca 3 months, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #9752

    lilzenbca
    Participant
    • Started: 9
    • Replies: 7
    • Total: 16

    I currently have the folloing measure to calculate a date when the 90% threshold is breached:

    CALCULATE( MINX(
    FILTER( RELATEDTABLE(‘CPU Ave with ETS Forecast’), ‘CPU Ave with ETS Forecast'[CPU Ave Forecast] > .90 && TODAY() < ‘CPU Ave with ETS Forecast'[Date]),
    ‘CPU Ave with ETS Forecast'[Date]
    ))

    I’m trying to figure out how to subtract days from that date in order to have an actionable target date.

     

    Thanks.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.