Forum Discussion
Target table power BI desktop
Good afternoon,
I'd like to add a target table to a report already containing several DBs.
All these databases are related to two main ones in order to be able to connect them together:
- to a Calendar table for the dates
- to an agent mapping table to track info about the agents.
What I need to create is a table that would give me the chance to have a view at year, quarter, month and week level for the targets of each agent present in the mapping file. Consider that the only target I have is yearly.
The only thing that comes to my mind is that I should create 365 entries for each agent (one per day), add the column date, and the column Target with the total yearly target / 365.
The problems are that 1) I don't know how to code that and 2) I'm 100% sure there are other more effective ways to achieve the same result.
Thanks a lot in advance for your help.
Alex
2 Replies
- amitchandak
Super User
alexbaldessarro , Not very clear to me.
See if this file to allocate target can help
https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0
Check for newly created tables
- alexbaldessarro
Microsoft Employee
I'm not 100% confident this is what I'm looking for.
I need to create a table, starting from a list of names (the vendors), and define for each one of them their daily target (currently I have only yearly) and to be able to slice it down to day/week level.