Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filling in for Missing Data?

I have a table that looks like this:   What am I trying to do is some forecasting analytics but I have an issue with missing data. Each month, a user in Salesforce will have an opportunity ei...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Sorry to reply late. Please try this:

    Create measures like so:

    Sum of Quota % max per month = MAX('Monthly Quota Table'[Quota %])
    Annual Quota Measure = SUMX ( ALL ( 'Main Table' ), 'Main Table'[Annual Quota] )
    * Quoted Revenue = [Annual Quota Measure]*[Sum of Quota % max per month]

     

    For detasils, please check the attached PBIX file.

     

    Best Regards,

    Icey

     

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

kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

You can write measures that will work around these problems, but we will need to know more to advise you on those. Is there any chance you can post a small copy of the power bi file ?