topic Dax to get active contracts in the current year and last year by using status Colum. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3713522#M144507 <P>Hi All,<BR /><BR />I have a requriment to get the active contracts by using DAX.<BR />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.</P><P><img /></P><P>&nbsp;</P><P>Scenario 2 : with the help of above active/Inactive status we need to calculate below win/Loss</P><TABLE><TBODY><TR><TD><SPAN>&nbsp;</SPAN></TD><TD>2022</TD><TD>2023</TD><TD>WIN or LOSS</TD></TR><TR><TD>case 1</TD><TD>Inactive</TD><TD>Inactive</TD><TD>Not Applicable</TD></TR><TR><TD>Case 2</TD><TD>Inactive</TD><TD>active</TD><TD>WIN</TD></TR><TR><TD>Case 3</TD><TD>active</TD><TD>active</TD><TD>ORGANIC</TD></TR><TR><TD>Case 4</TD><TD>active</TD><TD>Inactive</TD><TD>LOSS</TD></TR></TBODY></TABLE><P><BR /><BR />Thanks in advance.</P> Wed, 21 Feb 2024 08:06:33 GMT Anonymous 2024-02-21T08:06:33Z Dax to get active contracts in the current year and last year by using status Colum. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3713522#M144507 <P>Hi All,<BR /><BR />I have a requriment to get the active contracts by using DAX.<BR />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.</P><P><img /></P><P>&nbsp;</P><P>Scenario 2 : with the help of above active/Inactive status we need to calculate below win/Loss</P><TABLE><TBODY><TR><TD><SPAN>&nbsp;</SPAN></TD><TD>2022</TD><TD>2023</TD><TD>WIN or LOSS</TD></TR><TR><TD>case 1</TD><TD>Inactive</TD><TD>Inactive</TD><TD>Not Applicable</TD></TR><TR><TD>Case 2</TD><TD>Inactive</TD><TD>active</TD><TD>WIN</TD></TR><TR><TD>Case 3</TD><TD>active</TD><TD>active</TD><TD>ORGANIC</TD></TR><TR><TD>Case 4</TD><TD>active</TD><TD>Inactive</TD><TD>LOSS</TD></TR></TBODY></TABLE><P><BR /><BR />Thanks in advance.</P> Wed, 21 Feb 2024 08:06:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3713522#M144507 Anonymous 2024-02-21T08:06:33Z Re: Dax to get active contracts in the current year and last year by using status Colum. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3715008#M144574 <P>Sounds straightforward. What have you tried and where are you stuck?</P> Wed, 21 Feb 2024 17:29:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3715008#M144574 lbendlin 2024-02-21T17:29:37Z Re: Dax to get active contracts in the current year and last year by using status Colum. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3715851#M144628 <P>we are stuck to comepare 2023 and 2022 values, As we want to create a&nbsp;stacked bar chart we need the count of win/loss by month.</P> Thu, 22 Feb 2024 04:00:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-to-get-active-contracts-in-the-current-year-and-last-year-by/m-p/3715851#M144628 Anonymous 2024-02-22T04:00:50Z