TestDBSnips.docx (345.0 KB) Hello all,
*Fiscal 4-5-4, so weekly is necessary.
First post here in the forum, typically I can sort the solutions by previous posts, but this one is a challenge to solve.
The related video is ’ Compare Time Periods With Non Standard Date Tables - DAX & Power BI’ by Sam M…
I am trying to compare sales by week for last year using the method in the video for sales grouped by a disconnected table.
I added notes , test DB too large to upload. Let me know if this is enough info. thank you !