Forum Discussion

AMS_Pag's avatar
AMS_Pag
Frequent Visitor
6 years ago
Solved

Filter rows based on dates comparison

Hi, I have a table containing the vehicles that I currently have in my stock. The vehicles theirselves have a STOCK_START_DATE (which is the date they entered my stock in) and a STOCK_END_DATE (whic...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Create measure

     

    Measure =

    var max_start=calculate(max(table[STOCK_START_DATE]),all(table))

    return

    if(max(table[STOCK_END_DATE])<max_start,1,-1)

     

    And then add this measure to your visual level filter and set it to 1.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

AMS_Pag's avatar
AMS_Pag
Frequent Visitor
6 years ago

Sorry but I didn't understand what you mean by:

 

Anonymous wrote:

First drag table visual and in table visual drag required column.

 

Can you explain me with more details?

 

Thanks again!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

There is visualization section.

 

Select table visual.

 

Then drag required fields in table visual.

and drag measure to visual level filter.

 

  • AMS_Pag's avatar
    AMS_Pag
    Frequent Visitor
    6 years ago

    Thanks, it works!