Forum Discussion
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 Why not just Create Year = YEAR(TODAY())
or am I missing something?
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!