topic Re: weekly report et cumul in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/3766074#M146972 <P>Bonjour,</P><P>Je voudrais réaliser ce rendu, il s'agit de cacluler le taux de présence,&nbsp;j'utilise la fonction divide</P><P><img /></P><P>mais j'obtiens ce résultat</P><P><img /></P><P>&nbsp;</P><P>Lorsque je test le denominateur cela fonctionne mais des que le divise toute à ligne passe en "vide"</P><P>La valeur doit être "vide" quand la personne n'est pas présente (exemple Jean Naimare en feb)</P><P>&nbsp;</P><P>Merci de votre aide et à dispo pour compléter le besoin</P> Fri, 15 Mar 2024 10:36:56 GMT Gwen 2024-03-15T10:36:56Z weekly report et cumul https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2205862#M51905 <P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 24 Nov 2021 13:02:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2205862#M51905 Gwen 2021-11-24T13:02:58Z Re: weekly report et cumul https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2206260#M51926 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291965" data-lia-user-login="Gwen" class="lia-mention lia-mention-user">Gwen</a> , Can you paste the requirement in text format. </P> <P>&nbsp;</P> <P>In case you wow and WTD</P> <P>Power BI — Week on Week and WTD <BR /><A href="https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3" target="_blank">https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3</A><BR /><A href="https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123" target="_blank">https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123</A><BR /><A href="https://www.youtube.com/watch?v=pnAesWxYgJ8" target="_blank">https://www.youtube.com/watch?v=pnAesWxYgJ8</A></P> Wed, 24 Nov 2021 16:46:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2206260#M51926 amitchandak 2021-11-24T16:46:11Z Re: weekly report et cumul https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2207219#M51985 <TABLE><TBODY><TR><TD>&nbsp;</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>FILTER PAGE :&nbsp;</TD><TD>Week 2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Graph1&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Graph2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><TABLE><TBODY><TR><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P></TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><TABLE><TBODY><TR><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P></TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>DATA</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Biz</TD><TD>Week</TD><TD>Deal</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>Biz</TD><TD>Deals of the Week</TD><TD>&nbsp;</TD><TD>Biz</TD><TD>Deals Cumulative</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Jean</TD><TD>1</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Jean</TD><TD>0</TD><TD>&nbsp;</TD><TD>All Team</TD><TD>"1+0+1+2 = 4"</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Jean</TD><TD>2</TD><TD>0</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Robert</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Jean</TD><TD>3</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Robert</TD><TD>1</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Robert</TD><TD>2</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><TABLE><TBODY><TR><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P></TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Robert</TD><TD>3</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Example with "Week 3"</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>FILTER PAGE :&nbsp;</TD><TD>Week 3</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Graph1&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><TABLE><TBODY><TR><TD>Graph2</TD></TR></TBODY></TABLE></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Biz</TD><TD>Deals of the Week</TD><TD>&nbsp;</TD><TD>Biz</TD><TD>Deals Cumulative</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Jean</TD><TD>1</TD><TD>&nbsp;</TD><TD>All Team</TD><TD>"1+0+1+2 +1+1= 6"</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Robert</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Thu, 25 Nov 2021 07:44:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2207219#M51985 Gwen 2021-11-25T07:44:47Z Re: weekly report et cumul https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2207220#M51986 <P>desole je n'arrive pas à faire mieux</P><P>&nbsp;</P> Thu, 25 Nov 2021 07:45:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/2207220#M51986 Gwen 2021-11-25T07:45:13Z Re: weekly report et cumul https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/3766074#M146972 <P>Bonjour,</P><P>Je voudrais réaliser ce rendu, il s'agit de cacluler le taux de présence,&nbsp;j'utilise la fonction divide</P><P><img /></P><P>mais j'obtiens ce résultat</P><P><img /></P><P>&nbsp;</P><P>Lorsque je test le denominateur cela fonctionne mais des que le divise toute à ligne passe en "vide"</P><P>La valeur doit être "vide" quand la personne n'est pas présente (exemple Jean Naimare en feb)</P><P>&nbsp;</P><P>Merci de votre aide et à dispo pour compléter le besoin</P> Fri, 15 Mar 2024 10:36:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/weekly-report-et-cumul/m-p/3766074#M146972 Gwen 2024-03-15T10:36:56Z