Forum Discussion
Measure for conditional formating with more than 1 condition and using columns from related tables
I am trying to create a measure (i'm not sure if a measure or calculated column is what i should be using) that will ultimately be used purely for conditional formatting. I know how to navigate the c...
DataNinja777
Super User
Super UserHi Grella ,
In my opinion, in order to do it properly, in addition to the store close date field, we need the information of when the store opened so that we can see the duration of the period during which the stores were in operation (to highlight in blue where there were no sales and in yellow if that is after the closure). Without the opening date information, we cannot determine regarding the past information whether the lack of sales (to be blue highlighted) is due to the store not being open for that month (not starting up) or due to poor performance.
Best regards,
I have included supporting files with open date data also, appreciate any assistance.