Forum Discussion

cpiercey's avatar
cpiercey
Frequent Visitor
6 years ago
Solved

Calculated Column Constraints with Data Table

Hello, I am experiencing an unexpected issue with a calculated column and I am wondering if it has to do with the way I created the table it is referencing. I have the following tables:   1. Unfilt...
Need Help
  • cpiercey's avatar
    cpiercey
    6 years ago

    Thanks for the response, AllisonKennedy. I ended up adding additional context to the original formula which allowed the calculation to execute at the row-level. The end result needed to be a summation of quantities for each item in a given time period based on a transaction table with many transactions for that item. I have it working now, I also took your advice on the DimDate table, thanks for the tip.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

cpiercey 
I wonder why do you create the column in table 4 while it calculate with the column in table 3. Why don't you just create the column in Table 3.

 

Basically the expression column of Calculate(xxxx) must from the current table, you can filter with others tables if there is a relationship, something like:

 

2018 Q1 Demand = CALCULATE(sum('Filtered Demand'[Total Quantity]), 'Filtered Forecast'[Date - Year] = 2018, 'Filtered Forecast'[Date - Quarter] = 1)

 


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.