Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help with power BI formula

Hi everyone, I need your help please on a formula to be able to have a report on power BI. Bellow the problem that i'm facing: I need to extract a data from a table to calculate the monthly cost a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi v-frfei-msft

     

    Sorry for my late response, actually the problem is no longer persisting.

    I have just changer the parameters in the matrix and it worked.

     

    Sorry for my late response.

    Regards,

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Thanks for your response

Here is the table of the costs

Could you please tell me how works the "merge query"? I just started to use power Bi lately (may be a month ago) so i'm not that good with it.

 

Regards,

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Creating relationship between your tables is the key in your scenario. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-frfei-msft

     

    Sorry for my late response, actually the problem is no longer persisting.

    I have just changer the parameters in the matrix and it worked.

     

    Sorry for my late response.

    Regards,