Dax to get active contracts in the current year and last year by using status Colum.

[Anonymous]

Hi All,

I have a requriment to get the active contracts by using DAX.
Scenario 1: If the contract is active in any one month of the year need to consider as a active contract. and If the contract is inactive in all the months of a year need to consider as a inactive, like below.

Scenario 2 : with the help of above active/Inactive status we need to calculate below win/Loss

	2022	2023	WIN or LOSS
case 1	Inactive	Inactive	Not Applicable
Case 2	Inactive	active	WIN
Case 3	active	active	ORGANIC
Case 4	active	Inactive	LOSS

Thanks in advance.

[Anonymous]

we are stuck to comepare 2023 and 2022 values, As we want to create a stacked bar chart we need the count of win/loss by month.

[lbendlin]

Sounds straightforward. What have you tried and where are you stuck?