Forum Discussion

adnankabina's avatar
adnankabina
Icon for Helper II rankHelper II
1 year ago
Solved

logic on two column from different table

I have two table joined with PO and DC columns both exists in both table and created a relationship. I have YYYYWK 202534 in first table and YYYYWK  202545 from second table. I want to put condtion i...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi adnankabina,

    I have tried to reproduce your scenario in Power BI and used sample data with Zone and DC combination. The DAX has been modified to use MAX() inside CALCULATE so it works even when there are duplicate Zone–DC rows.

    The result now flags as Live when the YR_WK is greater than the tracker week, Not Live otherwise, and No Tracker when there’s no matching record.

    I’m attaching a sample PBIX file for your reference  you can check the DAX and visuals for better understanding.

    Hope this helps if you have any queries we are  happy to assist you further.
    Best Regards,
    Harshitha.


Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi adnankabina,

I would also take a moment to thank grazitti_sapna  , Anonymous  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi adnankabina,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.