Hello everyone.
Of course thank you for any help. I am struggling to do the following: I have the challenge of adding up the amounts of an expense, but I must do it through several criteria. The main catalog has two columns, ACCOUNT | KEY1 and this one emerges several possible combinations, the image that I attach can help to understand what I want to do, what is in red is what would correspond to the expense.
Could I do it with DAX?. I have three valid cases to take the expense:
1. ACCOUNT y KEY1
2. Solo ACCOUNT
3. Key1 only
In the example the total would be $670
Thanks for any help
About your first criteria ,you can merge the two table like this in power query .
Then expand table like this :
Now table is like this
Regarding to your second criteria,base on the upper ,still merge
Then expand like this:
Now the table is like this:
And about the third criteria , same as upper ,but this time merge base on key1 field
Best Regards,
Community Support Team _Isabella
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
About your first criteria ,you can merge the two table like this in power query .
Then expand table like this :
Now table is like this
Regarding to your second criteria,base on the upper ,still merge
Then expand like this:
Now the table is like this:
And about the third criteria , same as upper ,but this time merge base on key1 field
Best Regards,
Community Support Team _Isabella
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
