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.
I have a table with "Date added" and "Week commencing", and I'd like to find the max Date added for each Week commencing:
Date added | Week commencing | Value |
29/07/2019 | 29/07/2019 | 10 |
29/07/2019 | 05/08/2019 | 20 |
29/07/2019 | 12/08/2019 | 50 |
01/08/2019 | 29/07/2019 | 20 |
01/08/2019 | 05/08/2019 | 40 |
01/08/2019 | 12/08/2019 | 100 |
So in this example the first line should have a max Date added of 01/08/2019. What's the best way of doing it - Query Editor or adding a new column to the table, and what formulas/functions can I use? thanks a lot for your help!
Solved! Go to Solution.
Hi @redhughes
If you want to add a new column to the table:
NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
Hi @redhughes
If you want to add a new column to the table:
NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
thank you!!
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |