Forum Discussion
Aggregate data by month, count rows that meet condition and filter by not grouped by columns
I have a table with the following columns: Date by day Value sold Goal value Company I want to aggregate the value sold and goal value by month, then check wether each month surpassed it's goa...
Hey v-luwang-msft, thanks for answering!
Your solution didn't actually work for my intended purpose. The resulting column:
COUNTSATISFIED ACCORDING MON
shows me the count for how many companies met their goal each month. I wanted to check how many months met the aggregated goal, and be able to filter out companies to see the results.
The solution you proposed is static, what I mean by that is that it's not affected by filters.
Anyway I learned some new things from your post, thanks!
v-luwang-msft
Community Support
Community SupportHi PadilhaBI ,
Could you pls share a sample data,and expected output?
Remember to remove confidential data.
Best Regards
Lucien