Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to proceed with grouping the Amount column (by SUM) based on Month column by filtering out the Invalid entries from the Validity column first, so, we should end up having:
How to accomplish this filtration thing in the grouping step please?
@Anonymous I may be wrong, most of the time I am :), but I don't think that filtering is possible with the grouping step.
However, you can do grouping by validity and month and simply filter by validity to get your desired output.
Hope this helps, if you have any better option I am all ears!
I need all entries, so, no, filtering out before grouping does not solve that scenario.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.