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

Sorry, here is the table structure.

Budget(budget id, year, department, budget amount)

Contract(budget id, year, contract id, contract amount)

 

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

NicoH 

 

I mean, are you using the columns from the dimension table in visual? 

 

  • NicoH's avatar
    NicoH
    Regular Visitor
    4 years ago

    Yes, I tried and it can calculate the budget amount correctly, but the contract amount did not.

    Now I'm using the composite key for 2 tables: budgetid_year in budget table, budgetid_year_contractid in contract table. 

    • vojtechsima's avatar
      vojtechsima
      Super User
      4 years ago

      Hi, NicoH 
      did you check my newest post on this article?