Forum Discussion

ta19's avatar
ta19
Regular Visitor
4 years ago
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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.