Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear community
Somehow i am stuck up in a sumif type situation in power BI. My screenshot is as under
I have highlighted two fields in yellow. Precisely, I want to sum the "BILLAMOUNT" by filtering the "Date" column for the respective date in each row. This means that for each row when the month is same, i should get same filteretd total.
Appreciate your help.
Regards
Solved! Go to Solution.
Hi @Waseem
Try with this one
Test = SUMX ( FILTER ( Pre_Rev_PAYG, Pre_Rev_PAYG[Date] = EARLIER ( Pre_Rev_PAYG[Date] ) ), Pre_Rev_PAYG[BILLAMOUNT] )
Hi @Waseem
Try with this one
Test = SUMX ( FILTER ( Pre_Rev_PAYG, Pre_Rev_PAYG[Date] = EARLIER ( Pre_Rev_PAYG[Date] ) ), Pre_Rev_PAYG[BILLAMOUNT] )
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |