November 6, 2019
I built a dashboard that has numerous tabs (used your webinar) based on queries in power query. My dashboard is tracking deficiencies found during inspections completed quarterly and sometimes there can be duplicate deficiencies from one Quarter to the next for a given site. My site numbers are in the first column and deficiencies show in the 3rd column. I would like to add conditional formatting to my deficiency column (Question) but it needs to only find duplicates for each site, not the whole tabular pivot table. Is this possible and if so could you please assist with the formula I would need to use to apply conditional formatting for each store? Unfortunately my file is too large to send to you but have attached a snip it of the one page.
July 16, 2010