Forum Discussion
hunt511
3 years agoRegular Visitor
substract multiple columns from multiple tables
hey all, trying to figure this one out, i have to count for all the unccounted hours. this will look like x=(a-b) - (c-d). i tried to do just that,creating a quick measure for (a-b) then anothe for...
- 3 years ago
its a simple math problem, each value (a,b,c,d) its a column in different tables.values are decimal numbers. your link takes me to merge columns.
1Daniel993
3 years agoHelper III
Hello you can do that (easy way) in power Query
https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d#:~:text=Select%20two%20or%20more%20columns,Select%20Transform%20>%20Merge%20Columns.
- hunt5113 years agoRegular Visitor
its a simple math problem, each value (a,b,c,d) its a column in different tables.values are decimal numbers. your link takes me to merge columns.