Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to have a column showing the lastest date of an inspection for a given project, but I cannot seem to return the right dates.
This is what the table currently looks like showing the dates of when inspections happened (green dots are 1 project, blue is another)
When I change the formatting to latest date, it changes to this:
Althought this is what I want for the count of inspection (grouping by the project), it is not showing me the latest inspection date (e.g. 02/02/21 for the green dot project). I have tried DAX measures but it isn't returning the correct dates. I believe it is formatting to this due to the date hierarchy, but I cannot make the date look at only when inspections occured.
Note: I am live connected, and it won't let me create DAX's with the date without a funciton before it. When I have tried ALL it says "a table of multiple values was supplied where a single value was expected".
Please let me know if there are any questions on this, thanks!
Solved! Go to Solution.
@BotBot1 , Try if these can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@BotBot1 , Try if these can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
57 | |
21 | |
19 | |
19 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |