Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi. Asking for you help how can I create a custom column in power query where it will get the next latest date after the max date in a Date column. For example, in the column below the max date is 17/04/2024 then the next latest date is 27/03/2024. I want to get the 27/03/2024 in a created column.
Thank you very much for your help.
-Third
Solved! Go to Solution.
@third_hicana ,Go to the Add Column tab.
Click on Custom Column.
Use the following formula to get the next latest date:
Proud to be a Super User! |
|
@third_hicana ,Go to the Add Column tab.
Click on Custom Column.
Use the following formula to get the next latest date:
Proud to be a Super User! |
|
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
151 | |
121 | |
73 | |
71 | |
63 |