Forum Discussion

jimmy46's avatar
jimmy46
Regular Visitor
2 years ago

Dax Formula not returning values

Hello everyone, I'm still new to PowerBI and trying to get the hang of things.    I have two tables called Opportunity and Sales Rep Promotion dates connected by OwnerId to SFDC ID.   I created a...
jimmy46's avatar
jimmy46
Regular Visitor
2 years ago

Hi Yulia, here's some screenshots of the data:

 

It's some simple Short date data. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jimmy46 

     

    I would like to apologize for the belated reply.

     

    Below is my test.

     

    sample data:

     

     

    relationship:

     

    I used the formula you gave directly, and the result is as follows

     

     

    I can't reproduce your problem, could you please provide more details?

     

    Best Regards,
    Yulia Xu

     

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