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 ...
Please share what your raw data looks like.
Anonymous ,
Okay, yeah. So, create a date dimension table and set up the relationship to your created date column. Then create measures to sum whichever value column(s) you want. Then when you build your visuals, you can apply the date hierarchy for whatever granularity you wish.