Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
Kindly need to resolved my issue.
Basically, I want to count the unique values by monthly and excluding the childrenId that counted in the previous month and also I need the total of the number of children id for add and delete status. here my illustration table.
ChildrenId | Date | Status |
1 | 1 january 2020 | Delete |
2 | 2 january 2020 | Delete |
3 | 3 january 2020 | Add |
4 | 3 january 2020 | Add |
1 | 1 february 2020 | Delete |
2 | 1 february 2020 | Delete |
3 | 1 february 2020 | Delete |
4 | 2 february 2020 | Add |
For the total add and delete children id, I though I already correct number used "distinctcount" function and filtered by status.Please see the dax that I used :
Add Children ID =
Add Children ID =
but the problem is when I try to create "Monthly Chart", distinct count function also counting ChildrenId that already count in the previous month.
Is it there any way or dax that can be used that can exclude the ChildrenId that already count in the previous month ??
Any help from expert will be really appreciated.
Hi @TaufikMaggangka .
Use the below DAX formulaes;
1)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
43 | |
31 | |
24 | |
23 | |
22 |