I’m new to Power Bi and Dax and I’m trying to achive a 12 week moving average.
Issues - My table has no values each row is a transaction in the main table.
I want to ignore weeks where there are no transactions for a paticular store.
I need to analyse by store on one visual so i can compare the average of each store over time and check variances.
I’m a bit lost with the logic and most examples I have preactice all have sales totals and my data is based on row counts.
I have three tables: 1. date 2. Transactions multiples dates , multiple stores, multiple customers, multiple sales persons. 3. Store table list of all the stores what sales area they belong to and who is responsible.
I will create a 4th table an aggregate of the transaction - total count for each store as a table.
Can any one help, I’m getting myself mixed up.