Forum Discussion

Justair07's avatar
Justair07
Resolver I
7 years ago
Solved

Filter by Previous Working Day

Hello,   I need this DAX to look at a column for the previous working day and is the value is greater than 0 than return the value for the previous working day, otherwise return 0.   Daily VOC = ...
Need Help
  • Justair07's avatar
    Justair07
    7 years ago

    Anonymous Hello, bacically I just wanted the DAX to show previous working day. For example since today is Tuesday 3/26/2019 the returned date should be Monday 3/25/2019. If to day was Monday 3/25/2019 then the returned value should be Friday 3/22/2019. I think I have it now, What do you think? I needed to change the 4 to a 5.

    IF (
                WEEKDAY ( TODAY (), 3 ) < 5,
                TODAY () - 1,
                TODAY ()
                    - ( 7 + WEEKDAY ( TODAY (), 3 ) )
            )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

It would be helpful if you provided a sample of your data to demonstrate what you're looking to do.

 

Thanks,

Ben

Justair07's avatar
Justair07
Resolver I
7 years ago

Anonymous Hello, bacically I just wanted the DAX to show previous working day. For example since today is Tuesday 3/26/2019 the returned date should be Monday 3/25/2019. If to day was Monday 3/25/2019 then the returned value should be Friday 3/22/2019. I think I have it now, What do you think? I needed to change the 4 to a 5.

IF (
                WEEKDAY ( TODAY (), 3 ) < 5,
                TODAY () - 1,
                TODAY ()
                    - ( 7 + WEEKDAY ( TODAY (), 3 ) )
            )