Forum Discussion
Solved
Power Query Group Data where value is >= 0
Hello All, I have a Table show below Ask is to Group the data by [Month] and Count Rows where [Value] >= 0. I have used below M-code but it is faulty. = Table.Group(#"Changed Type", {"Mon...
You do no "group by". My solution:
1) Filter first the column
2) Group by
The result:
You do no "group by". My solution:
1) Filter first the column
2) Group by
The result:
I cannot filter the data >=0 as there are other columns also which are being used for different calculations.
Than you have to make a full data example please! 🙂
And your desired result.
For the "group by" you have to think about what should happend to the second column.
No worries. I did a workaround as you suggested. I created separate table, Disabled Load in Report, and appended the table based on Date. Solved the problem