Maximum date from minimum date (measure)

Question

Hi, I am trying to create measure that will return Maximum date from another measure.First measure is in Site, Group, Item levelSecond, should be on Site, item level only.First measure is calculating first available date. Second shoould return max from MinAvailableDate_WC for Site Item.result for second measure should be 2/5/2024 for 0000-214692-02 and 2/12/2024 for A110-20003-01&nbsp;MinAvailableDate_WC =VAR __DS0Core = &nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[Site],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[WorkCenterDescription],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'New_CapacityTable'[Date],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "M_RunningSub_Balance5", '_Measures'[M_RunningSub-Balance5]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; "TotalCapacity", CALCULATE(MAX('New_CapacityTable'[TotalCapacity]))&nbsp; &nbsp; )VAR FilteredDS0Core =&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; __DS0Core,&nbsp; &nbsp; &nbsp; &nbsp; '_Measures'[M_RunningSub-Balance5] &gt;= [TotalCapacity]&nbsp; &nbsp; )VAR MinDateWithCapacityExceededScalar = &nbsp; &nbsp; MINX(FilteredDS0Core, 'New_CapacityTable'[Date])RETURN&nbsp; &nbsp; MinDateWithCapacityExceededScalar

lbendlin · Answer

You cannot measure a measure.&nbsp; Implement your business logic from scratch.

Forum Discussion

Maximum date from minimum date (measure)

1 Reply

Related content

Running Maximum

Average of minimum/maximum

Conditional Formatting when minimum and maximum are the same

Color gradient, dynamic minimum and maximum values

Get Minimum and Maximum of Count