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
Please can I have some help with the following:
I have the following DAX creating a table that is pulling Item from the main items table. As you can see from the screen shot below some items have had multiple revisions. How do I create a table that shows the highest revision number. so in the table below i would like to only see revision 20.0
Any help would be much appreciated.
Solved! Go to Solution.
Can you try
summarize(les_items_data,les_items_data[item_id],les_items_data[Tile],"Max Revison",Max(les_items_data[Revision_Number] ) )
and let us know if it works or not.
Regards
sanalytics
if it is your solution then please like and accept it as your solution
Can you try
summarize(les_items_data,les_items_data[item_id],les_items_data[Tile],"Max Revison",Max(les_items_data[Revision_Number] ) )
and let us know if it works or not.
Regards
sanalytics
if it is your solution then please like and accept it as your solution
Hi sanalytics
yes that did work if I took out the Title element which changed on each revision.
Many thanks
I've Kudos your last post 😁
Could I ask for a little more help!
by applying your solution i get the following result
I gather the summarize is saying each of the titles is unique hence why they are showing. I only want to show the Title with MaxRevision 20 (in this example). My ulitimate goal is to have a table that shows the most recent Item Title for each Item_id.
Thanks for the reply. Since posting the database owner has changed his requirements and no longer requires what I am trying to achieve. Your initial help was much appreciated though
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |