3
votes

I have created a calendar table using the DAX code below, but I am trying to swap out the date "04/04/2000" for a dynamic date, which is the first date of the financial year 4 years previous to todays date. Is this possible?

Date Table2 = CALENDAR(("04/01/2000"),TODAY())
1

1 Answers

0
votes

Give this a try:

Date Table2 = CALENDAR(DATE(YEAR(TODAY()-365*4);4;1);TODAY())