Target Totals

[ls784]

Hi, I'm new to this and thought this would be a simple one but I haven't been able to figure it out.

I have my data for tasks completed by workers, and a separate Target spreadsheet which shows the monthly target for each worker. I'm trying to create a table to compare monthly data to the target and as a percentage, however the targets aren't totalling if I choose to look at multiple months.

What I need is a table/matrix that shows the totals per month, but also shows me the totals dependant on the time period I've chosen to look at. Is there a way of doing this or do I need to store the target data differently? I was also wondering if it was possible to have it automatically default to only show you the previous 3 months of data based on todays date?

Targets for "Time associated" table:

Name		Target per month
Worker 1		0
Worker 2		1000
Worker 3		500
Worker 4		0
Worker 5		0
Worker 6		0
Worker 7		0
Worker 8		1200
Worker 9		1000

Example of Data: 

Completed By	Date		Time Associated
Worker 2	29/06/2023		0
Worker 6	29/06/2023		0
Worker 6	29/06/2023		15
Worker 9	29/06/2023		60
Worker 9	27/06/2023		10
Worker 2	27/06/2023		60
Worker 4	26/06/2023		0
Worker 8	25/06/2023		10
Worker 8	25/06/2023		20
Worker 8	25/06/2023		10
Worker 8	25/06/2023		20
Worker 8	25/06/2023		15
Worker 8	25/06/2023		15
Worker 8	25/06/2023		10
Worker 8	25/06/2023		25
Worker 8	25/06/2023		15
Worker 8	25/06/2023		20
Worker 8	25/06/2023		20
Worker 2	23/06/2023		30
Worker 2	23/06/2023		45
Worker 2	23/06/2023		180
Worker 1	23/06/2023		0
Worker 1	22/06/2023		0
Worker 1	21/06/2023		0
Worker 9	21/06/2023		0
Worker 9	20/06/2023		0
Worker 9	20/06/2023		0
Worker 1	19/06/2023		0

Any help would be really appreciated.

[mlsx4 · Accepted solution]

Hi @ls784 

For showing the value according to the month, I always use a kind of multiplicator, which later on multiply to the final result:

var multiplicator= DISTINCTCOUNT('TABLA DE FECHAS'[Mes])
return result*multiplicator

[ls784]

Amazing, I knew it would be something simple. This did the trick!

Do you know if the second part of my question is possible? "I was also wondering if it was possible to have it automatically default to only show you the previous 3 months of data based on todays date?"

[mlsx4]

Hi @ls784 

I'm not sure...I suppose you will have to play with some "tricks" using bookmarks and so on.

I have seen that there are several threads talking about it. 

Take a look at them and see if it solves the problem:

•  https://community.fabric.microsoft.com/t5/Service/Make-report-default-to-last-3-months-on-first-open...
• https://community.fabric.microsoft.com/t5/Desktop/How-to-show-by-default-based-on-latest-3-months-av...
• https://community.fabric.microsoft.com/t5/Desktop/latest-three-months-in-slicer-as-default-with-filt...