Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the following table created on PowerBI
The value in date is created using =DateTime.LocalNow() function and then formatted to give date, so everytime I refresh it's going to change dynamically to the current date.
Now I want to add next row which has previous week from today's date (23/10/2023) and the next row to have last year from today's date (30/10/2022). How do i get this?
Thanks in advance!
Solved! Go to Solution.
You can create CustomColumn for each of your Dates. Then use Unpivot to transform from Columns into Rows.
Please see attached file for detailed Power Query steps.
Trust this is the solution you are looking for.
Regards,
You can create CustomColumn for each of your Dates. Then use Unpivot to transform from Columns into Rows.
Please see attached file for detailed Power Query steps.
Trust this is the solution you are looking for.
Regards,
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |