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 Power Bi community
I have a table which contains the status of diffrent projects at diffrent times.
It look like this.
I want to find the last stateid based on the date and todoid.
So I use a Dax formular like this.
Luckly a higher id always means a later date so I can use this Dax code.
Solved! Go to Solution.
@Greg_Deckler
Ok I found the problem.
I used a calender table so one slicer could affect multiple tables.
But the date colum in my table was thype = time date/ time while my calender table colum hads the type = date.
Thanks a lot for the help Greg, sometimes you just need the right question to start thinking in a new way.
A moderator can close this thread.
Hi @ThomasWeppler ,
Glad to hear that your problem has been solved. Could please mark your reply as a solution and then more people will benefit from it.
Best Regards,
Stephen Tao
@ThomasWeppler If you are using your Dato column as your date filter then assuming this is a slicer or something in the Filter pane then this should already be filtering your rows in that table. Is that what you are doing or something else?
@Greg_Deckler
Ok I found the problem.
I used a calender table so one slicer could affect multiple tables.
But the date colum in my table was thype = time date/ time while my calender table colum hads the type = date.
Thanks a lot for the help Greg, sometimes you just need the right question to start thinking in a new way.
A moderator can close this thread.
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |