Forum Discussion
Reflecting Weekly Consecutive Dates
The goal is to have a table reflect transactions on a consecutive weekly (or monthly) track highlighting the number of transactions made during the week. There is a calendar dimension table which is ...
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 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!