Forum Discussion
Conditional Sum based on dates, custom month input
I see posts like these, but this is beyond my skill level and I hope someone would help me with my case. I want to create four sums: if transaction date this year then sum if transaction date ...
I'm not sure I fully understand without seeing some sample data. However, if you create a date dimension table and establish a relationship to the date column on your transaction table, you should just be able to use a simple SUM measure on the value column.