Forum Discussion
Calculated Column Constraints with Data Table
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.
You are doing a SUM inside a calculated column, which is generally not advised. You have nested it inside a CALCULATE which does change the context and makes it provide ok results, but I still don't recommend this approach.
What do you want as an end result?
Try using calculated MEASURES for some of your formulas instead, and put them in a matrix visual with Year and Quarter.
I also recommend using a DimDate table rather than the Forecast table dates: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
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.
- cpiercey
Glad you got it working!
Please can you mark this post as solved so others know it is resolved and can find the solution easily?
Thanks!