topic Re: checking account in range in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/checking-account-in-range/m-p/3070689#M106557 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="511822" data-lia-user-login="Bobass75" class="lia-mention lia-mention-user">Bobass75</a>&nbsp;</P><P>your sample dataset is not sufficient to reflect the challenge, please consider enrich it.&nbsp;</P> Thu, 09 Feb 2023 02:20:56 GMT FreemanZ 2023-02-09T02:20:56Z checking account in range https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/checking-account-in-range/m-p/3070015#M106494 <P>Hello<BR />I am struggling with checking accounts from given fact list with another list where there are ranges f.eg</P><TABLE><TBODY><TR><TD><STRONG>account fact list</STRONG></TD></TR><TR><TD>3011</TD></TR><TR><TD>3012</TD></TR><TR><TD>3015</TD></TR><TR><TD>3030</TD></TR><TR><TD>3032</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Account range list</STRONG></TD><TD><STRONG>no of range</STRONG></TD></TR><TR><TD>3011-30159</TD><TD>1</TD></TR><TR><TD>3020-3020</TD><TD>2</TD></TR><TR><TD>3041-30459</TD><TD>3</TD></TR></TBODY></TABLE><P><BR />The first range is covering accounts: 3011 3012 3013 3014 3015 30151 30152 30153 30154 30155 ... 30159<BR />The account 3041 will be in the third range but not in the first<BR />All accounts numbers are text<BR />The result should be column of "no of range" besite every account in fact table<BR />I will be much obliged for any suggestions of DAX or M measure<BR />Thanks in advance<BR />Leszek</P> Wed, 08 Feb 2023 18:56:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/checking-account-in-range/m-p/3070015#M106494 Bobass75 2023-02-08T18:56:08Z Re: checking account in range https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/checking-account-in-range/m-p/3070689#M106557 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="511822" data-lia-user-login="Bobass75" class="lia-mention lia-mention-user">Bobass75</a>&nbsp;</P><P>your sample dataset is not sufficient to reflect the challenge, please consider enrich it.&nbsp;</P> Thu, 09 Feb 2023 02:20:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/checking-account-in-range/m-p/3070689#M106557 FreemanZ 2023-02-09T02:20:56Z