Forum Discussion

vehloaaron's avatar
vehloaaron
Frequent Visitor
2 years ago

Is MIN/Filter the right approach? Help - Sample data in link

Hi Power BI Community -    Our marketing leaders have asked if we can build out some custom attribution models for marketing campaigns in PowerBI.  Based on what I know of the data, this can be don...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi vehloaaron ,

Based on the information you provide, you can use a combination of the CALCULATE , MAX, and FILTER functions to determine the latest marketing campaign response date that is less than or equal to each milestone date for each business opportunity. To better address your question, could you provide more data (without sensitive information) and your desired output.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

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

vehloaaron's avatar
vehloaaron
Frequent Visitor
2 years ago

Thank you and I appreciate your guidance Anonymous I have attached a drop box link to PBIX file with sample data and a screen shot of a pivot chart I did in excel with expected outcome

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi vehloaaron ,

    Thank you for your reply, unfortunately I can not open the link above, could you try providing a screenshot of the data in order for me to test and help you with this issue.

     

    Best Regards,

    Ada Wang

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

    • vehloaaron's avatar
      vehloaaron
      Frequent Visitor
      2 years ago

      Anonymous Sure, I attached screenshots in the main post