Forum Discussion

SJ25's avatar
SJ25
Resolver I
6 years ago
Solved

Filtering Table based on if condition

Hello All,   I have a table with shipments data & want to sum the amount of shipments for the previous day. So if today is Monday, I want to filter the table for Friday (Today -3) but if today is a...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    SJ25 

     

    Try something like this

    MeasureVal = 
VAR _weekday =
    WEEKDAY ( TODAY (), 2 )
VAR _x =
    IF ( _weekday = 1, 3, 1 )
VAR _result =
    CALCULATE (
        SUM ( 'Table1'[ShipmentAmount] ),
        FILTER ( 'Table1', Table1[ShipmentDate] - _x )
    )
RETURN
    _result



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

  • SJ25's avatar
    SJ25
    6 years ago

    Thank you all for the quick answers. I was able to make it work using:

    CALCULATE(SUM('Table1'[ShipmentAmount]),
    FILTER('Table1',IF(WEEKDAY(TODAY(),2)-1, 'Table1'[ShipmentDate]-TODAY()-3, 'Table1'[ShipmentDate]-TODAY()-1)))
parry2k's avatar
parry2k
Super User
6 years ago

SJ25 check this post

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡