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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jimmy46 

 

Could you please provide some sample data and the expected results based on the sample data? That would be very helpful. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

At present, I can only give you some suggestions based on your formula for your reference.

 

Since your previous formula, which works fine, has already calculated the earliest closing opportunity time for each OwnerID, and from your description it seems that there is a relationship between the two tables, I think the second formula may not need to calculate FirstCloseDate again. You can try to use the first formula directly in the second formula.

 

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.