Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
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.
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.
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.
You are welcome. Share the link from where i can download your PBI file.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I applied that filter after I applied Filter Rows and Filter Rows1.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |