Forum Discussion

alexbaldessarro's avatar
alexbaldessarro
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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