Date Between filter not working

[abinashphuel]

I used the between filter to filter on RcptPostingDate (date DataType), but the outcome was not what I expected

I filtered the dates to be between 12/01/2021 and 12/31/2021, but I got data from 11/30/2021 to 12/30/2021 and not from 12/31/2021.

[abinashphuel · Accepted solution]

I used another apprach to filter because none of the suggested solutions worked for me. (Error wass so random).

My Approach: instead of fiiltering date, I filtered month.

[v-xiaotang]

Hi @abinashphuel 

Have you solved this question with the help of enthusiastic users? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @abinashphuel 

What are the contents of other filter steps? If it still doesn't work ok, please provide a sample file with that issue, we will check it later, thanks.

Or you can duplicate that table, and remove other steps bellow, to see whether it works fine.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

You will see the effect of your filter condition only when you click on the next step in the Applied steps section i.e. FilterRows1.

[abinashphuel]

Hi Ashish, Thank you!

I took screenshot that way so I could show the formula at the top. But even I clicked to the last step or apply data, filter is not working.

[Ashish_Mathur]

You are welcome.  Share the link from where i can download your PBI file.

[aj1973]

Hi @abinashphuel 

It looks like you shifted position of the step applied and I suspect the Modified format of the column is not quite in place, that's why Power Query can't recognise the date column as Date format.

Re check the steps applied

[abinashphuel]

I applied that filter after I applied Filter Rows and Filter Rows1.