Forum Discussion

apuente2011's avatar
apuente2011
New Member
8 years ago
Solved

OR Statement for 2 dates

I am trying to limit records in the data that i am pulling to only records within the last 7 days based on two different dates. I can do this in SQL but not sure where in Power BI. In SQL i would lik...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Use this formula :

     

    Flag = IF(Table1[Date1]=TODAY()-7 ||Table1[Date2]=TODAY()-7, "1","0" )

     

     

    Then add this Flag in the visual filter and filter for values "1" .

    Thanks

    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Use this formula :

 

Flag = IF(Table1[Date1]=TODAY()-7 ||Table1[Date2]=TODAY()-7, "1","0" )

 

 

Then add this Flag in the visual filter and filter for values "1" .

Thanks

Raj

  • apuente2011's avatar
    apuente2011
    New Member
    8 years ago

    Thank You. This Worked, just needed to add the > sign