https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-values-for-the-same-ID-in-a-table-on-one-row/m-p/3464187#M132167 <P>1. where are you doing this formatting on column or measure?<BR />2. Do you want the sum of values and then represent them in the given format?<BR />3. Can you please share the Format string?</P> Fri, 06 Oct 2023 15:32:31 GMT _elbpower 2023-10-06T15:32:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-values-for-the-same-ID-in-a-table-on-one-row/m-p/3464142#M132166 <P>Hi all,</P><P>&nbsp;</P><P>CFE, PBL, and VAK are stored as INT values, but these needed to be transformed into a certain format (like this: "99,80"). I achieved this using format and convert.</P><P>&nbsp;</P><P>When I put the INT values in a table; all values are placed on one row for every ID.</P><P><img /></P><P>&nbsp;</P><P>However, when I place the transformed CFE, PBL and VAK values in a table; the values are separated over multiple rows for every ID. I need them to be placed on one row, like in the screenshot above. Does anyone have an idea how to fix this?</P><P><img /></P><P>&nbsp;</P><P>Thanks!</P> Fri, 06 Oct 2023 15:18:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-values-for-the-same-ID-in-a-table-on-one-row/m-p/3464142#M132166 Anonymous 2023-10-06T15:18:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-values-for-the-same-ID-in-a-table-on-one-row/m-p/3464187#M132167 <P>1. where are you doing this formatting on column or measure?<BR />2. Do you want the sum of values and then represent them in the given format?<BR />3. Can you please share the Format string?</P> Fri, 06 Oct 2023 15:32:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-values-for-the-same-ID-in-a-table-on-one-row/m-p/3464187#M132167 _elbpower 2023-10-06T15:32:31Z