Forum Discussion

bkuhlmann's avatar
bkuhlmann
Frequent Visitor
2 years ago

DateAdd Not Working As Expected

Hi Everyone - I'm using DATEADD to compare current QTD values against QTD values from the prior year. The SQLBI article linked below indicates that I should be able to breakout last year's QTD figure...
bkuhlmann's avatar
bkuhlmann
Frequent Visitor
2 years ago

Thanks Greg! I almost have your "Hard Way" working for me, but I'm struggling to return the correct MaxYear...I don't want the max year from the calendar table, rather I want the current year. I'm trying to filter the table to return the current year from my calendar table by using filtering it down based on Create Date = TODAY() but I'm struggling to return a single value to the variable. I've tried numerous functions to no avail. Thanks in advance!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    bkuhlmann Why not just Create Year = YEAR(TODAY()) 

    or am I missing something?

    • bkuhlmann's avatar
      bkuhlmann
      Frequent Visitor
      2 years ago

      I was trying to use my calendar table because our fiscal year does not match our calendar year, and I also need to get both the FY and FQ. I could recreate those formulas in the measure but would prefer to pull from the calendar table instead.

       

      Is there a way to get the FY and FQ for "today" from my calendar table instead?

      Thanks for your help!