Forum Discussion
Question: Date Table Required for Date/Time functions...?
You're probably better off using something online like Azure Marketplace calendars. They update for you so you don't have to keep up with it.
You'll need to set up an Azure Marketplace account (free) and browse to find a calendar you like. Once you find one and either buy or get it for free, you will receive an feed key that will grant you access for refreshing and such.
Under your Get Data menu, if you click more options, you will see the Azure Marketplace option.
When prompted, add the Feed Key and it will import the master calendar for you.
Once you have this imported, all of your date functions will reference this.
Example:
Total Income MTD Last Year = CALCULATE([Total Income], DATEADD(DATESMTD('Opportunity Allocations'[Start Date]), -1, YEAR), ALL('Calendar'[Date]))Where 'Calendar' is the name of the calendar you imported from the Azure Marketplace.
Hope this helps.
You're probably better off using something online like Azure Marketplace calendars. They update for you so you don't have to keep up with it.
You'll need to set up an Azure Marketplace account (free) and browse to find a calendar you like. Once you find one and either buy or get it for free, you will receive an feed key that will grant you access for refreshing and such.
Under your Get Data menu, if you click more options, you will see the Azure Marketplace option.
When prompted, add the Feed Key and it will import the master calendar for you.
Once you have this imported, all of your date functions will reference this.
Example:
Total Income MTD Last Year = CALCULATE([Total Income], DATEADD(DATESMTD('Opportunity Allocations'[Start Date]), -1, YEAR), ALL('Calendar'[Date]))Where 'Calendar' is the name of the calendar you imported from the Azure Marketplace.
Hope this helps.
Could you give an example of a calendar resource in the marketplace? I've gone in there and am simply searching "calendar" but I'm not really sure what I should be looking for. All the results returned seem to be much more involved that what I'm looking for.
thanks