Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PBI sum up Price column

Hello all,  I have question regarding total value which take qty and unit price from 2 different table I have AvgNetPrice raw data from in table Net_Price and Current Fcst from another table....
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Anonymous ;

    Can you share data from two simple tables? And their relationship, in general, we use sumx(summarize()) to correct total?

    It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    Solved: How to upload PBI in Community - Microsoft Power BI Community


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous ;

Can you share data from two simple tables? And their relationship, in general, we use sumx(summarize()) to correct total?

It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Solved: How to upload PBI in Community - Microsoft Power BI Community


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have resolve it with summarize(). 

Thank you 😉