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 Community,
this is my current dataset in PowerBI
could you help me write a formula that takes the next row time to use as a end date?
it should look like this eventually:
thanks a lot in advance for all the help
Kind regards
Solved! Go to Solution.
Hi @alevandenes,
You can achieve this by adding an index colum thru power query first.
Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)
Then create a calculated column -
If you dont see the result as above, ensure you have the right data type selected.
Hi @alevandenes,
You can achieve this by adding an index colum thru power query first.
Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)
Then create a calculated column -
If you dont see the result as above, ensure you have the right data type selected.
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |