Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey I have created a bridge table .Now i am uanle to sort out following calculation:
IF(VW_DETBRKG1[Breakage Date]>VW_DETJOBM4_2[INIT_DATE],"yes","No")
I tried using lookup but it throws cicular dependancy error.
Hi @Anonymous
Thanks for reaching out to us.
could you share some sample data for us to check if thay way is possible? thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
i think you are lookupvalue from many side to another many side?
not sure if you can get the correct answer.
you can try
maxx(filter(vm1, vm1[jobno]=vm2[jobno]),date)
Proud to be a Super User!
User | Count |
---|---|
77 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
47 | |
46 |