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.
Dear All, I need your help!
I want to find the first country in result from the first Date & Time of the each "Number".
I have attached the PBIX for your reference.
Thanks
Gaurav
@gauravnarchal , Not very clear from your file and description. If the country's driving number and date or reference no.
One Idea was to have Rank(Column) based no or date another one is using firstnonblankvalue
Hi @amitchandak
For each "Number" there are multiple countries with different date and time. I want to filter the first country that is with first date and time.
See below screenshot, in which Number 2855526352 is having 2 countries Singapore and Thailand.
I want the result to show only Singapore as the first date is 2/1/2019 4:00:00PM
Do you think I can achive this with a measure?
Result
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |