I have a sample data as below and I would like to create a powerbi card. The dax code should first groupby based on Source
and add the sum of max(FYandFW)
. How to get around with this ?
Source FYandFW num sum
Company A 202453 1**
Company A 202452 2
Company A 202451 3
Company B 202501 4
Company B 202502 5**
Company B 202453 6
Expected Answer 1+5 = 6