Forum Discussion
Duplicate values removed from sum
Need your help BI wizards. I have a report for which an employees hours worked appear next to the associated date. This report also shows services rendered. So here's the rub. For a day like November...
You may just change the aggregation to Count and Maximum.
https://docs.microsoft.com/en-us/power-bi/service-aggregates
I created a calculated field in tableau that did the job. Just have to do it in BI. Below is my tableau field
{ FIXED [Date of Service], [Provider Name]:MIN([Hours])}