Filter column by date and by another date

[foging]

Hello,

I have this table where I'm filtering "Project status" by YearMonth, using my date dimension. Now, in the same visual table I need to show the "Project status" from another date, lets say 7 months back. I have found solutions for this using measures, but I don't need aggregations, I need to show text. This is what I need:

ID      Projects status Period X        Projec status Period Y

001      Active                                  Delayed

Is this possible in any way?

[v-kkf-msft · Accepted solution]

Hi @foging ,

Please try to create a copy of the Table: Table 2. Then create the following relationship. You can use two date slicers to filter the contents of each of the two tables.

Or just use the following measure without creating a copy of the Table to calculate the corresponding state.

Measure = 
CALCULATE (
    MAX ( 'Table'[Projects status] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Date]
            IN VALUES ( Dates[Date] )
                && 'Table'[ID] = MAX ( 'Table'[ID] )
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[foging]

Yes, I have two slicers and I have two date table, "date" and "previous date". But I can't get the "previous date" to filter only "Project Status Period Y". Everything gets filtered on "date", but not on "previous date". I have found measures that work, but I to show the content of the column, in plain text.

[amitchandak]

@foging , You need two period slicer for that

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Compare two Brands: https://youtu.be/exN4nTewgbc