Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

One row by firstdate

Hello I am new to power bi and I have some problems with a report. I have a table that looks like this: ------------------------------------1----------------------------------- ID DateBuy Fr...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please use this version instead

    Filter Measure = 
VAR SelectedDate = SELECTEDVALUE ( 'Date'[Date] )
VAR CurrentDate = CALCULATE ( MAX (Data[DateBuy] ), REMOVEFILTERS ( 'Date' ) )
VAR NextDate = CALCULATE ( MIN ( Data[DateBuy] ), ALLEXCEPT ( Data, Data[ID] ), Data[DateBuy] >= SelectedDate )
RETURN
    IF ( CurrentDate = NextDate, 1 )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your quick feedback. however, I have a small problem with your solution. When I choose the date of 02/07/2022 I should no longer have ID: 1A46 available. But it is tjr available in my table

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
Actually when you add the measure to the visual it behaves normally

Apparently the measure behaves differently when placed in the filter pane only. I don't have a ready answer for that but I'll look into it.