Aplying conditional filters in table

[mcantos]

Hi community, 

I have this table I created  Power Bi desktop, which already contains some filters such as stage (Stage 1 or Stage 2 or Stage 3), Status (Active and Declined):

but I don't know how to apply additional filters to validate: If status="Declined" then take the "Declined Date" from the current month to get this

It seems the alternative is to create a new Calculated table but I don't have that option. Are there any other ways to do it? 

Thank you!

[mcantos]

Thank you so much @v-yiruan-msft ,

That's exactly what I needed. 

[Uzi2019]

Hi @mcantos 

Try this calculated column

New Date =

var A= DATE(YEAR(TODAY()),MONTH(TODAY()),DAY('Product Status'[Declined Date]))

var b= IF('Product Status'[Status]="Declined",A,BLANK())

RETURN b

and check the screenshot below.

In the screenshot all the status which value are decline have replaced their month and year value by keeping the Day value.

I hope I answered your question!

[mcantos]

Thank you @Uzi2019  for your replay but I don't want to change the dates and sorry because I think I was not clear enough

 I want to keep the dates and apply a new filter that allows me to keep the products with "Active" status and products with "Declined" status and the declined date is in the current month. So, in the end, after applying the filters I must have as result these two rows: 

Thank you again

[v-yiruan-msft · Accepted solution]

Hi @mcantos ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Flag = 
VAR _product =
    SELECTEDVALUE ( 'Table'[Product] )
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Table'[Product] ),
        FILTER (
            'Table',
            'Table'[Status] = "Active"
                || (
                    'Table'[Status] = "Declined"
                        && YEAR ( 'Table'[Declined Date] ) = YEAR ( TODAY () )
                )
        )
    )
RETURN
    IF ( _product IN _tab, 1, 0 )

2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)

Best Regards