Forum Discussion
Dymanic data source
Hi there, I would really appreciate some help / advice about setting up dymanic data source for a power BI report. I have set up a Power BI report as follows: a matrix table like this ...
Hi,
The forecast table (Table B) should have 2 date columns - one which tells us the month for which the forecast is and another which tells us the Month in which the forecast was prepared. Using the USERELATIONSHIP() function, we should be able to get what you want.
"a bit clumsy" is a nice way to put it. I think it is irresponsible for your business requestors to ask you to create such a challenging report with the current experience. Try to work on the issue piece by piece. Starting with the 23 tables will get you nowhere. Start with Ashish_Mathur 's suggestion.
Hi Ashish,
Thank you very much for your help.
Could I please check if I have interrupted your advice correctly?
- add secondary column in Forecast table (Table B):
- add forecast version in model and build relationship with Table B
- create new meature to calculate forecast revenue:
- CALCULATE(SUM(Table B[Forecast Revenue]), USERELATIONSHIP(Calendar Month[Calendar Month], Forecast Version[Forecast Version]))
Much appreciated.
Kind regards,
Janis
Yes, i think so.