Forum Discussion
Anonymous
6 years agoNot applicable
Calculated column ..**Its urgent PLz****
Hi All, Below is my table with data Product Type Sales pen A 7 Pen A 9 Pen B 7 Pen B 4 Pen B 10 Pen B 5 Pen B 8 Pen C 4 Pen C 4 Rubber A ...
Anonymous
6 years agoNot applicable
This might help, write following DAX measures:
Amount=SUM([Values])
NumOfDistinctDates=DISTINCTCOUNT([Date])
Avg=DIVIDE([Amount],[NumOfDistinctDates])