After save file to another name , filter field not working ?

[admin11]

Hi All

I try to set chart with filter for field = Show_3_YR = 1 for PBI file name =PBI_V18

After that i create a bookmark , and save bookmark at button. and it work fine.

The issue happen when i try to save file as PBI_BACKUP

And i notice that filter for field = SHOW_3_YR , no more working. so the chart display wrong value.

Can some one advise me where go wrong ?

Paul

[PC2790]

Hi @admin11 ,

Can you trying creating the measure like:

difference =
IF (
    DATEDIFF ( NOT ( ISBLANK ( <YourColumnname> ) ), TODAY (), DAY ) > 3 * 365,
    1,
    0
)

See if it works

[admin11]

Hi PC2790

i get error below :-

[PC2790 · Accepted solution]

You will need to change the column name to INVC[Last Sales].I have edited my reply to reflect the same.