Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.