Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-chuncz-msftHi, I'm trying to apply it but I don't see how because I'm working from multiple tables.. I have the ID from Products, a '1' for every ID that includes the sliced datetime based on the entries, a '1' for every ID that includes the sliced datetime based on the durations, the minimum start date that belongs to the duration(s) that includes the sliced datetime... and now I just need to pick up the corresponding Category that belongs to a certain ID and minimum start date. 

 

 

Measurex = 
MAXX(
    TOPN( 1; FILTER (
        Durations;
        Durations[Start] <= MAX ( 'calendar'[Date] )
            && Durations[End] >= MIN ( 'calendar'[Date] )
            && Durations[Start] <> BLANK ()
    ); ...; ... );
...
)

 

 

I feel like I'm overcomplicating..