Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how 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-...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey Anonymous 

     

    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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I tried the DAX code:

Dates - CALENDAR("2000-01-01","today( ) + 10")

It did not work!

For reference, I am looking at accident dates and I just want to know wha is the dax code I should use with a specified start dat and an unspecidied end date 

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Anonymous 

 

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Awesome you're the best it works!