Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
in excel formula is
=SUMIFS('Base File'!$O$2:$O$1760,'Base File'!$E$2:$E$1760,"="&Result!D6)
=SUMIFS('Base File'!$O$2:$O$1760,'Base File'!$E$2:$E$1760,"="&Result!D55,'Base File'!$M$2:$M$1760,">="&Result!$A$1,'Base File'!$M$2:$M$1760,"<="&Result!$B$1)
But in Dax sumifs is not working please help
we need help on two formula
@sameergupta60 , we have SUMX and with sum, we can use calculate and filter.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |