Forum Discussion

NicoH's avatar
NicoH
Regular Visitor
4 years ago

Need help on DAX function

Hi everyone I'm confused by the DAX function. I want to compare the budget and contract amount based on a table with the budget and contract info with the columns like BudgetID, Year, Budget Amount,...
Need Help
NicoH's avatar
NicoH
Regular Visitor
4 years ago

Could you let me know the linked key between Budget and Contract table?

 

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, NicoH 
There is a non-active relationship between BudgetID and BudgetID ( I can then call it in the measure I sent).

  • NicoH's avatar
    NicoH
    Regular Visitor
    4 years ago

    But it's a many-to-many link.

    • vojtechsima's avatar
      vojtechsima
      Super User
      4 years ago

      NicoH 
      Well, yeah, it's definitely not Ideal, but it did achieve what you wanted.

      • NicoH's avatar
        NicoH
        Regular Visitor
        4 years ago

        I tried but the result is not correct.