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,
I have a sample data as below and I would like to consider the record with max version over document number.
Expected Result set:
Appreciate for any quick help on this
Solved! Go to Solution.
I agree with @ibarrau . If you want a new table, you can do this:
Hi! you can just add Document number in a visualization (test it with table), if it's a data type number be sure to click on the arrow "Don't summarize". Then add version to the visualization and go to the arrow again but this time click on Max (it has to be a number/int data type).
That way you'll have the expected result.
Regards,
Happy to help!
I agree with @ibarrau . If you want a new table, you can do this:
Hi @ibarrau ,
I need only Document number and other columns in the Table graph for max version. (No need of version field in the table Graph)
it should be like the below,
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |