Forum Discussion
Solved
Get Calculated Column with status change for the same contract
Hello, i have the following table. I have basically two status (CC_STATUS_COBRANCA), Legal and Non Legal, i need to see if the contract changes status. Im trying to compare the curre...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhyXsdwnqkvgZqnNu?e=EGvBXQ
Hello,
i think the formula only works with one contract.
i've uploaded two tables, with one and two contracts
1) One contract Formula
result : perfect
2) with 2 contracts:
result :