Forum

Hi Catalin, Thank you! Good point about the Grand Total! In our scenario, this measure is never shown with a grand total (it doesn't make any se...

Hi Mynda, I managed to figure it out with a slight tweaking of the variable you provided. Change Sales = [Typical sales]- VAR previousP = CALCUL...

Hi Mynda, Thank you for sharing! 1. Currently, I have a similar solution implemented (based on MAX in the index column) but that - and your prop...

Hi Mynda, Thank you for you reply. Sorry, I somehow managed to leave out an important detail: I need the running average of the last 16 weeks. ...

If you have multiple sheets and multiple named tables, it might happen that you add the data twice - once from the table and once from the sheet.