Forum Discussion

Heiner26's avatar
Heiner26
Frequent Visitor
2 years ago

Creating Forecast based on Pipeline Values between Dates and conversion rate

Hey everyone, first of all: great support you give to the community 👏 encourages me to keep on discovering the potential of Power BI. Was searching this forum for a solution for the challenge i fa...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure how much i can help but i would like to try.  Share the download link of an MS Excel file with your sumproduct() formula already written there.  I will try to translate that formula into the DAX formula language.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    This is my abortive attempt.  I have not been able to get the total - just the count of rows in each month which satisfy all conditions.  Hope this helps marginally.

    • Heiner26's avatar
      Heiner26
      Frequent Visitor
      2 years ago

      thanks, Ashish!

      I appreciate your support very much and for sure this will help me on the way to the soultion 😉

      Will have a closer look during this week and I hope its fine to come back to you if there is any questions 🙏☺️