Forum Discussion

Aladin46's avatar
Aladin46
Frequent Visitor
3 years ago
Solved

Browsing through duplicated records

Hi all,   I'm trying to work out something that looks simple but ends up tricky... Wouldn't be fun otherwise right? I'm having a table with let's say a list of documents with 4 basic columns: doc ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Aladin46 ,

    I created some data:

    Do you want to use the dax to display data that is not outdated, you can use the IF function to mark it, and then put it in the Filter setting to display the data.

    Here are the steps you can follow：

    1. Create measure.

    Flag =
IF(
    MAX('Table'[Date])>=TODAY(),1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

     

    If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Aladin46 ,

I created some data:

Do you want to use the dax to display data that is not outdated, you can use the IF function to mark it, and then put it in the Filter setting to display the data.

Here are the steps you can follow：

1. Create measure.

Flag =
IF(
    MAX('Table'[Date])>=TODAY(),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

 

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

 

Best Regards,

Liu Yang

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