Forum Discussion
Solved
Devide by one time in a multiple values
Hi, Hi, I have a time table with days_in_month field to count everyday in a month into a column and the value for this field is the same for each row belongs to a month. Now i want to cr...
You only need to make sure the expression for days is a result obtained by the corresponding aggregation function.
Like the measure formula provided by ankitpatira or something like below.
avgSales = SUM( Table1[Sales] ) / MAX ( Table1[days in month] )
Best Regards,
Herbert
You only need to make sure the expression for days is a result obtained by the corresponding aggregation function.
Like the measure formula provided by ankitpatira or something like below.
avgSales = SUM( Table1[Sales] ) / MAX ( Table1[days in month] )
Best Regards,
Herbert