https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701326#M143946 <P>You can use table (matrix)</P><P>put ID number in rows</P><P>put week number and&nbsp; number of entery in a week as a values&nbsp;</P><P>In my opinin no need for formula</P> Thu, 15 Feb 2024 13:18:54 GMT bati1212 2024-02-15T13:18:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701317#M143945 <P>Hi,</P><P>&nbsp;</P><P>Thanks for looking at my post. I am looking for any Power BI gurus to help me in following logic please</P><P>&nbsp;</P><P>I am looking for formula for understanding how many times in a week respective ID numbers are login&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Any idea please?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 15 Feb 2024 13:13:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701317#M143945 jimpatel 2024-02-15T13:13:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701326#M143946 <P>You can use table (matrix)</P><P>put ID number in rows</P><P>put week number and&nbsp; number of entery in a week as a values&nbsp;</P><P>In my opinin no need for formula</P> Thu, 15 Feb 2024 13:18:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701326#M143946 bati1212 2024-02-15T13:18:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701363#M143951 <P>Perfect</P><P>&nbsp;</P><P>Thanks a lot <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 15 Feb 2024 13:38:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula/m-p/3701363#M143951 jimpatel 2024-02-15T13:38:44Z