Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
1Hi everyone,
Can you please help me with this question? I have got list of contracts since 2015 November to 2019 January. There are 2 types of them, active and expired. I need to calculate count of active contracts per month for each year
Solved! Go to Solution.
Suppose the contracts count is based on the start_date. You can create calculate column using DAX like pattern below:
result = CALCULATE ( COUNT ( Table[comment] ), FILTER ( Table, YEAR ( Table[start_date] ) = YEAR ( EARLIER ( Table[start_date] ) ) && MONTH ( Table[start_date] ) = MONTH ( EARLIER ( Table[start_date] ) ) ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Suppose the contracts count is based on the start_date. You can create calculate column using DAX like pattern below:
result = CALCULATE ( COUNT ( Table[comment] ), FILTER ( Table, YEAR ( Table[start_date] ) = YEAR ( EARLIER ( Table[start_date] ) ) && MONTH ( Table[start_date] ) = MONTH ( EARLIER ( Table[start_date] ) ) ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |