Live Weeks Approval.pbix (64.6 KB) Approvals.xlsx (9.7 KB) Dear DNA Team, I have created a rolling calendar using m-code. The attached excel data is loaded to PBI model. I am trying to calculate live/dynamic totals of approval per week but I would like to see only for 2-3 weeks from today date a…

Hi @jbressan This still isn’t what I am looking for and I asked for help with it. Apologies for being direct, I do appreciate your help. I don’t understand why I should still add Offset week if this is not needed in my scenario. Your formula kind of gave me a hint to obtain the result that I asked…

Live/ Dynamic Week Sales

DAX DAX Calculations

jbressan February 23, 2021, 2:36pm 3

Hi @Matty

Please Review Problem of the Week #5 - Dynamic Last N Weeks Trend

Video with the solution Link