Power bi -date add

Options
Veronica Krivis
Veronica Krivis
Tenth Anniversary Name Dropper Facilitator 1 Loyalty Badge
in SKY Developer General Discussions

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.

Tagged:

Comments

  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    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.

  • Rebecca Sundquist
    Rebecca Sundquist
    Seventh Anniversary Kudos 2 Name Dropper Participant

    Hello, @Veronica Krivis! I know this post is getting stale now, and I hope you found a Date table solution that is working for you. I added this template to the Community today:

    https://community.blackbaud.com/forums/viewtopic/586/64143

Categories