Forum Discussion

xonder's avatar
xonder
Icon for Helper I rankHelper I
5 years ago
Solved

Boolean statement if item exists between tow dates

I collect data of advertised vehicles at irregulars intervals. Each time I collect data, I get a snapshot of what is currently being advertised along with a time stamp.   05.11.2020 is the first da...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    xonder , Create a measure like this and try with ID

     

    measure =
    var _max = maxx(allselected(Table), Table[Date])
    var _tab =summarize(filter(Table, Table[Date] =_max),Table[ID])
    return
    calculate( count(Table[ID]), filter( Table, Table[Date] <_max && not(Table[ID] in _tab)))

  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi xonder ,

     

    You can create two measure for counting ID that are marked "Sold" and those marked "For Sale":

     

    ID For Sale  = CALCULATE(COUNT('Table'[ID]),FILTER('Table',[Status] = "For Sale"))
ID Sold  = CALCULATE(COUNT('Table'[ID]),FILTER('Table',[Status] = "Sold"))

     

     

    Put them in values  and it will show as legends.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi xonder 

1. Place ID in the a table visual

2. Create this measrue and place it in the visual

Measure = 
MAX(Table1[Date]) = CALCULATE(MAX(Table1[Date]), ALL(Table1[ID]))

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers