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,
I have a table like this
YEAR MONTH CUSTOMER AGE ORDERING
2023 JANUARY 0 A
2023 JANUARY 0 B
2023 JANUARY 1 C
2023 FEB 0 D
2023 FEB 3 E
2023 MARCH 0 F
2023 MARCH 0 G
2023 MARCH 0 H
2023 MARCH 4 I
From this table, I want to count the orderers with customer age 0 on a month basis. In other words, I want to calculate how many orderers with customer age in which month. As a result, I will create the following table.
YEAR MONTH NEW CUSTOMER COUNT
2023 JANUARY 2
2023 FEBRUARY 1
2023 MARCH 3
I would be grateful if you can help me write the dax formula required for this,
Kind regards
Solved! Go to Solution.
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 | |
14 | |
11 |
User | Count |
---|---|
43 | |
34 | |
25 | |
24 | |
23 |