Power bi -date add

Veronica Krivis

I was able to install the “Gateway” so thanks, Matt!!

I want to compare last year amount with this year amount by month and I use this formula: CALCULATE(SUM('CC'[Paid_v]),

DATEADD('CC'[date],-1,YEAR) )

It gave me the total for last year but it does not show me the total by month. Do I need to create a “date” table? I used a “date” column.

Matt Thacker

Hey @Veronica Krivis, yes, you'll definitely want to use a date table in this situation. DATEADD is a time-intelligence function which requires date fields that meet specific requirements. One of which is that the dates in the table must be continues, meaning no skipped days. If you use the Gift Date column and you had one day that no gifts were entered, it's going to throw off your calculations because DAX is going to try and account for all 365 day.