Forum Discussion
Solved
Dates in Power BI while filtering
Hello, So I am trying to filter one of my Table Columns using New Measure. But I am also trying to include specific date for this column. For the first column i am filtering it needs to pull yestrd...
Hi， ta19 ；
May be :
Requests Recieved = COUNTROWS ( FILTER ( Table1, Table1[ANum] && Table1[status] = "Active" && Table1[MovementTypeCode] = "Transfer" && [Request Date] = TODAY () - 1 ) )I don’t really understand what you mean, Could you please considier sharing some scenes and expected result so it is clear on what needs?
And It would be great if there is a sample file without any sesentive information here.
It makes it easier to give you a solution.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Forgot to mention that the columns name in my table is called "Request Date" that i need to use to filter out the dates.