Forum Discussion
Using a Date filter and KPI
Hi, I have a date, "Target Date", which has multiple date entries. I have it in a filter by "Relative Date" selections, for things like, weekly, bi weekly, etc. I also have an "Expectations" colu...
Hi,
So each CSV file that i pull in will have been called the name of the two week period. I have a calculation taking in the start and end dates as the period and use as a filter.
Looks like this
textperiod = CONCATENATE(CONCATENATE(CONCATENATE("Wk ",'Schedule Report'[Pay Period]),": "),CONCATENATE(CONCATENATE('Schedule Report'[startdate]," - "),'Schedule Report'[Enddate]))
and this is the calc for the Pay Period
Pay Period = FLOOR(DATEDIFF(DATE(2020,1,05),'Schedule Report'[Target Date],DAY)/14,1)+1
I am attaching another file(HTML) with units and expectations
Basically each day they have an expecation of 1.2 units and they have the # of units completed and Productivity Units.
I want to use the filter for Period and have the units accounted for in each period chosen and the Productivity Units.