Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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  ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.

  • lbendlin's avatar
    lbendlin
    5 years ago

    "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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

lbendlin's avatar
lbendlin
Super User
5 years ago

"bridging tables"  - that is not recommended. Use proper dimensions to control these unrelated fact tables.

 

The ask should be doable with the right data model.  What data model do you have so far?