deleting relationship throws error (USERELATIONSHIP function can only use the two columns references participating in relationship) in Lost Customers and New Customers calculation
I would need to see your file in order to know what is the problem but generally speaking if you follow the same approach as in my file you should be fine
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
it worked, I deactivated the relationship between sales and thismonth and between sales and previousmonth and changed the cross filter direction to both from manage relationships
Thanks a lot for your time and help :-)
@hansel well done !
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.