Forum Discussion

bendejnp's avatar
bendejnp
Icon for Helper I rankHelper I
4 years ago
Solved

Date Filter with daily update

Hello together,   I have a problem and I am trying to solve it since a couple of days.    I have created report that is published PBI services and it is updated automatically every morning contai...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bendejnp ,

     

    Please create a measure like below and add it to visual filter set value = 1.

    flag =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( slicer[date] ) = "today", IF ( SELECTEDVALUE ( 'fact'[date] ) = TODAY (), 1, 0 ),
    SELECTEDVALUE ( slicer[date] ) = "yesterday",
        IF ( SELECTEDVALUE ( 'fact'[date] ) = TODAY () - 1, 1, 0 ),
    IF (
        FORMAT ( SELECTEDVALUE ( 'fact'[date] ), "YYYYMMDD" ) IN VALUES ( slicer[date] ),
        1,
        0
    )
)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi bendejnp ,

 

Please create a measure like below and add it to visual filter set value = 1.

flag =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( slicer[date] ) = "today", IF ( SELECTEDVALUE ( 'fact'[date] ) = TODAY (), 1, 0 ),
    SELECTEDVALUE ( slicer[date] ) = "yesterday",
        IF ( SELECTEDVALUE ( 'fact'[date] ) = TODAY () - 1, 1, 0 ),
    IF (
        FORMAT ( SELECTEDVALUE ( 'fact'[date] ), "YYYYMMDD" ) IN VALUES ( slicer[date] ),
        1,
        0
    )
)

 

Best Regards,

Jay