Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dax help

I have data in 2 tables as below. The tables are not related in BI Desktop. How do I write a formula in DAX to achieve this?   Table 1   Role                       Total Mission Hours By Region N...
Dax Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Well, you have to decide what you want to do. I can't tell you, it's your business after all :)

     

    You could sum up all the values in the corresponding rows or you could take the min/max... you could do many things but it's you who has to decide. You could also return BLANK if there is more than 1 corresponding row. It's your call, mate :)

     

    Best

    Darek

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Thanks for replying!

 

I gave an overview of what I am trying to achieve. there is more than 1 row in T1.

 

What can be done if this is the scenario?

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Well, you have to decide what you want to do. I can't tell you, it's your business after all :)

 

You could sum up all the values in the corresponding rows or you could take the min/max... you could do many things but it's you who has to decide. You could also return BLANK if there is more than 1 corresponding row. It's your call, mate :)

 

Best

Darek