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.
Hi All,
I am trying to filter out the data by top 2 date (Earliest date i.e., jan 1 and jan 2 in below data)
But when i select earliest it is showing up jan 8 data
and when i select latest date then also it is showing jan 8.
Not sure why it is not showing Jan 1 when i select earliest.
Thanks in Advance
Thanks in Advance
Solved! Go to Solution.
Hi,
Try filtering with bottom instead of top
Check if can do the same with help of rank
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi @Anonymous ,
Can you please share the measures Earliest Date and Latest Date so we can understand the issue more. And do you have a seperate Date table in your model?
Hi @Tara_
I am just dragging and dropping date column to visual level filter as a result it will be showing earliest or latest whatever based on our selection.
Earliest date is Jan 1.
Latest date is Jan 8.
No i dont have date table in my model.
Thanks
Here are some responses similar to your issue
https://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/td-p/442889
https://community.powerbi.com/t5/Desktop/Top-N-and-EARLIEST-function-in-power-bi/td-p/389439
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |