Forum Discussion
Month average
Hi Team, I have one transaction table on that i have values from Jan -2022 to Jan - 2023 But Oct data is missing in that. Month itself not available in transaction data. I have Date table a...
Hi Balhemkan
To get your problem solved:
At first make a measure:
SalesAmount=SUM(Facttable'[Sales])
Then make another measure for your Average as below which refers to previous measure:
AVERAGESalesAmount=
AVERAGEX(VALUES(Date_Table[YearMonth]),[SalesAmount])
If this answer solves your problem, please mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran