Forum Discussion
Creating a running total
I am trying to create a column that will display the running total for words. I am looking to sum the words for each vendor. Example data vendor words Sent to Vendor anticipated delivery d...
Create a separate date table using CALENDAR or CALENDARAUTO and do not link it to your fact table. Use the dates from this table in your visuals. Then you will use something like MAX to create a VAR that grabs your current date. You can then use this in FILTER statements against your fact table to filter down to the correct rows that you need to sum or subtract.
Thank you for your response. I created a date table, but am not sure how to write the proper dax syntax. Could you give me a sample dax syntax I could use?