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 Kornholio ,
I didn't find "units" column in your sample data but i did find "Expecation" column.
So basically you want the value/sum of "Expecation" multiplied by the count of selected "Period"? And should the target date within the selected "Period"?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
also this is the calc for the start and end date
startdate = CALCULATE(MIN('Schedule Report'[Target Date]),ALLEXCEPT('Schedule Report','Schedule Report'[Pay Period])Enddate = CALCULATE(MAX('Schedule Report'[Target Date]),ALLEXCEPT('Schedule Report','Schedule Report'[Pay Period]))