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.
Hello all
If possible, i wanna know for each row, in edit queries, the max and the min of a specific date field for each reserv ID. 1 column each.
I did it in the table view and also by grouping (duplicating the previous qry) but i believe it's better, for future calculations that i should have these new 2 columns on the query, as well as faster.
Can you help me please?
Solved! Go to Solution.
Hi pedromooji,
You can use "Group by" in power query to achieve aggregated value by category. Please refer to: https://support.office.com/en-us/article/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-e...
Regards,
Jimmy Tao
Hi pedromooji,
You can use "Group by" in power query to achieve aggregated value by category. Please refer to: https://support.office.com/en-us/article/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-e...
Regards,
Jimmy Tao
That's it. Thank you very much
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |