Forum Discussion
OPS-MLTSD
Post Patron
Post Patronhow to create a date table with DAX code where there is no end date
I am trying to create a date table in Power BI to create a relationship between three queries. I wanted to know how do I create the date table with no ending date. I have a start date (which is 2000-...
Hey OPS-MLTSD
this article describe how to create a table using DAX:
https://docs.microsoft.com/en-us/power-bi/desktop-calculated-tables
This is the code to create a table with a given start date that ends with a date that is 10 days ahead of today, there are no quotation marks around the end date parameter:
Dates = CALENDAR("2000-01-01", today( ) + 10)Regards,
Tom
OPS-MLTSDPost Patron
Post PatronI have already seen this article previsouly and it does not provide me the solution. If anyone could provide me with the actual DAX code, that would be great. Thank you
I always use this below logic in my reports. so there will be no maintenance.
DATES = // TO limit Dates table to only required dates, use dates from Fact table. Ex: Sales
Var MinDateDact = MIN(SalesFact[TxDate])
VAR MaxDateFACT = MAX(SalesFact[TxDate])
RETURN
CALENDAR(MinDateDact,MaxDateFACT)