topic Re: split column value based on another column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040418#M45795 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Mark this as a solution, if I answered your question. Kudos are always appreciated.</P><P>Thanks</P><P>&nbsp;</P> Thu, 26 Aug 2021 12:30:01 GMT Tanushree_Kapse 2021-08-26T12:30:01Z split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040342#M45788 <P>i have two column&nbsp;</P><P>&nbsp;</P><P><SPAN>PR Compliance</SPAN> :&nbsp;</P><P>&nbsp;</P><P>PR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PR DATA</P><P>Within&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>Over&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>Over&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2</P><P>Within&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>Within&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>&nbsp;</P><P>&nbsp;</P><P>i am trying split&nbsp; value avergat&nbsp; based PR value i&nbsp; have used following measure&nbsp;<BR /><BR /></P><DIV><DIV><SPAN>PR Compliance -over val = </SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV><SPAN>AVERAGE('PR Details'[PR ]),</SPAN></DIV><DIV><SPAN>'PR Details'[PR]="Within"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>i am getting Error&nbsp; "The function AVERAGE cannot work with values of type String." any&nbsp;</SPAN></DIV></DIV> Thu, 26 Aug 2021 12:03:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040342#M45788 Anonymous 2021-08-26T12:03:46Z Re: split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040387#M45791 <P>Anonymous</LI-USER>&nbsp;Try</P> <DIV><SPAN>PR Compliance -over val =</SPAN></DIV> <DIV><SPAN>CALCULATE(</SPAN></DIV> <DIV><SPAN>AVERAGE('PR Details'[PR DATA]),</SPAN></DIV> <DIV><SPAN>'PR Details'[PR]="Within"</SPAN></DIV> <DIV><SPAN>)</SPAN></DIV> Thu, 26 Aug 2021 12:18:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040387#M45791 Greg_Deckler 2021-08-26T12:18:13Z Re: split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040404#M45792 <DIV><SPAN>Anonymous</LI-USER>&nbsp;</SPAN></DIV><DIV><SPAN>PR Compliance -over val =</SPAN></DIV><DIV><SPAN>CALCULATE(</SPAN></DIV><DIV><SPAN>AVERAGE(VALUE('PR Details'[PR ])),</SPAN></DIV><DIV><SPAN>'PR Details'[PR]="Within"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Hope this answer solves your problem! If you need any additional help please tag me in your reply.<BR />If my reply provided you with a solution, pleased mark it as a solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span> or give it a kudoe <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><BR />Thanks!<BR /><BR />Best regards,<BR />Gonçalo Geraldes</SPAN></DIV> Thu, 26 Aug 2021 12:25:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040404#M45792 goncalogeraldes 2021-08-26T12:25:55Z Re: split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040418#M45795 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Mark this as a solution, if I answered your question. Kudos are always appreciated.</P><P>Thanks</P><P>&nbsp;</P> Thu, 26 Aug 2021 12:30:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2040418#M45795 Tanushree_Kapse 2021-08-26T12:30:01Z Re: split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2052686#M46209 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp; &nbsp;i have month wise text count value like&nbsp;</P><P>&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp; PODetails</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;over&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>July&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>&nbsp;</P><P>My percentage&nbsp; want month wise&nbsp;</P><P>&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp;Over&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Grand Total&nbsp;</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100%</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100%</P><P>&nbsp;</P><P>&nbsp;</P><P>any idea month wise percentage ? thanks in advance</P> Thu, 02 Sep 2021 03:26:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2052686#M46209 Anonymous 2021-09-02T03:26:01Z Re: split column value based on another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2052687#M46210 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="301004" data-lia-user-login="goncalogeraldes" class="lia-mention lia-mention-user">goncalogeraldes</a>&nbsp;</P><P>&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp; PODetails</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;over&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>July&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within</P><P>&nbsp;</P><P>My percentage&nbsp; want month wise&nbsp;</P><P>&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp;Over&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; within&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Grand Total&nbsp;</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100%</P><P>June&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100%</P><P>&nbsp;</P><P>&nbsp;</P><P>any idea month wise percentage ? thanks in advance</P> Thu, 02 Sep 2021 03:26:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/split-column-value-based-on-another-column/m-p/2052687#M46210 Anonymous 2021-09-02T03:26:24Z