Forum Discussion
apuente2011
8 years agoNew Member
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 likely use something like select * where date1 > currentdate-7 or date 2 > currentdate-7
- Anonymous8 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
2 Replies
- AnonymousNot applicable
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
- apuente2011New Member
Thank You. This Worked, just needed to add the > sign