Forum Discussion
Paul_Cracknell
Jul 06, 2022Copper Contributor
Avg Sales Per Week Day using DAX
Hi, all. I have a dimension table that is a standard date dimension table - has all the usual elements (date, day of week, week number, month number, etc). I also have a fact table with sales for...
SergeiBaklan
Jul 06, 2022Diamond Contributor
It's not clear how you'd like to use it. If the model is like
you may add measure
Average Qty:=AVERAGE( Table1[QTY] )
and show it as