https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138408#M111946 <P><img /></P><P>In each column of the report, specific values are calculated for 4 stores based on the main data with synchronization with the calendar selection of day-to-day comparison.</P><P>What I would like to achieve is to calculate the highest and lowest values separately for each column so that you can connect a filter that will highlight the background color of the cell depending on whether it is the lowest or highest value. Unfortunately, such a comparison must be achieved separately for each column, although the data in the columns are dynamically calculated depending on the selection of a specific date in the calendar...<BR /><BR />In DIF columns, the values are calculated dynamically: period minus period equals the difference, maybe this is why the calculation of the highest and lowest value in the selected DIF column does not work, because the script does not see a specific value to calculate the lowest and highest value in the selected column, but I do not I understand how this can be achieved by adding the appropriate calculation so that you can connect filtering in these columns</P><P>It would be best if I could attach the report file but I don't know how to do it on this forum</P> Fri, 17 Mar 2023 10:26:30 GMT ESVAS 2023-03-17T10:26:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138408#M111946 <P><img /></P><P>In each column of the report, specific values are calculated for 4 stores based on the main data with synchronization with the calendar selection of day-to-day comparison.</P><P>What I would like to achieve is to calculate the highest and lowest values separately for each column so that you can connect a filter that will highlight the background color of the cell depending on whether it is the lowest or highest value. Unfortunately, such a comparison must be achieved separately for each column, although the data in the columns are dynamically calculated depending on the selection of a specific date in the calendar...<BR /><BR />In DIF columns, the values are calculated dynamically: period minus period equals the difference, maybe this is why the calculation of the highest and lowest value in the selected DIF column does not work, because the script does not see a specific value to calculate the lowest and highest value in the selected column, but I do not I understand how this can be achieved by adding the appropriate calculation so that you can connect filtering in these columns</P><P>It would be best if I could attach the report file but I don't know how to do it on this forum</P> Fri, 17 Mar 2023 10:26:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138408#M111946 ESVAS 2023-03-17T10:26:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138600#M111966 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="526117" data-lia-user-login="ESVAS" class="lia-mention lia-mention-user">ESVAS</a>&nbsp;,<BR />Can you please provide sample input and output so that I can help you quicker?<BR />Thank you.</P> Fri, 17 Mar 2023 11:13:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138600#M111966 KeyurPatel14 2023-03-17T11:13:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138741#M111977 <P><A title="DFD - TEST 19-AT.pbix file" href="http://92.43.35.179/PowerBI/" target="_self">http://92.43.35.179/PowerBI/</A>&nbsp;<BR /><BR /><BR /></P> Fri, 17 Mar 2023 12:11:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138741#M111977 ESVAS 2023-03-17T12:11:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138753#M111978 <P>Hi, thank you very much for your willingness to help with this report, because I don't know how to bite it to make it work...</P><P>It is true that I am fresh with building Power BI reports. I'm trying to transfer what I've done in MS Excel, but in Power BI it's a completely different story. It's probably best if you watch the source file</P> Fri, 17 Mar 2023 12:15:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Please-help-me-create-a-formula-for-each-column-in-the-table/m-p/3138753#M111978 ESVAS 2023-03-17T12:15:21Z