Forum Discussion
Reflecting Weekly Consecutive Dates
Anonymous , You can create a date table in power query and also create week start date and then merge these two tables on week start or end date
Date Table in Power Query: https://youtu.be/so_A22HXbwM
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Anonymous , You can create a date table in power query and also create week start date and then merge these two tables on week start or end date
Date Table in Power Query: https://youtu.be/so_A22HXbwM
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
amitchandak Thank you so much for your support. I just watched your video and will try to implement your advice. Just so I am clear on your advice, you are suggesting that I create a 2nd calendar table? What if my current Calendar dimension table already has Start/End Week? My sincerest apologies but I am confused on what you are advising.
amitchandak after a bit of work and testing, your advice served to work well! Thank you so much for the advice! Much gratitude for your support!