Please help me create a formula for each column in the table

[ESVAS]

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.

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...

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

It would be best if I could attach the report file but I don't know how to do it on this forum

[KeyurPatel14]

Hi @ESVAS ,
Can you please provide sample input and output so that I can help you quicker?
Thank you.

[ESVAS]

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...

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

[ESVAS]

http://92.43.35.179/PowerBI/