Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Missing Values in SUMX Function

Hi,   For context, I have sales data and forecast data for each department in a company. The sales data is a feed from SQL and the forecast data is a table in PowerBI as shown below (where each dep...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

Is it possible to provide sample data for Revenue[Department Name] and how this relates to the Budgets table? Provide as much data detail as possible, design to sensitive data please remove in advance.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.