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 )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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

MErci for the time you take to answer me. indeed I think you have solved my problem. Thanks again for your help 🙂