Forum Discussion
Solved
Show values on table based on columns from another table
Hello Im having some issues generating a table, hopefully I can get some guidance on how to solve this issue. I would be greatly appreciate it. Im trying to get the values from "Table B" to...
This is an efficient solution and works when you can only choose 1 date. If there is a need to select multiple dates then try:
Parts Planned =
CALCULATE(
SUM('TableB'[Parts Planned]),
TREATAS(
VALUES('TableA'[Date]),
'TableB'[Date]
),
TREATAS(
VALUES('TableA'[part number]),
'TableB'[part number]
)
)
This is an efficient solution and works when you can only choose 1 date. If there is a need to select multiple dates then try:
Parts Planned =
CALCULATE(
SUM('TableB'[Parts Planned]),
TREATAS(
VALUES('TableA'[Date]),
'TableB'[Date]
),
TREATAS(
VALUES('TableA'[part number]),
'TableB'[part number]
)
)
Smitho
Thanks a lot for the support. I was able to make it work in my model!