Forum Discussion
Solved
New column or measure based on two conditions
Hi PBI Experts, Looking for help with calculating a new column/measure which shows the sum of biggest sales amount per day for John and Matt Table1 Name Date Sales John ...
Topn didn't help.
I ended up creating a new column calculating the max of sales with allexcept name and date. Then created a measure which sum the new column divided by number of dates.
Topn didn't help.
I ended up creating a new column calculating the max of sales with allexcept name and date. Then created a measure which sum the new column divided by number of dates.