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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ashish,

 

I have downloaded the file.  Much appreciated for all your help.  It makes perfect sense and you have made it so easy to understand.

 

Thank you so much for your time.

 

Kind regards,

Janis

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  If my reply helped, please mark it as Answer.