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
Icon for Community Champion rankCommunity 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!