Forum Discussion

OPS-MLTSD's avatar
OPS-MLTSD
Icon for Post Patron rankPost Patron
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 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-MLTSD's avatar
OPS-MLTSD
Icon for Post Patron rankPost Patron
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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I tried this and its working:

 

Dates = CALENDAR( "2000-01-01",TODAY()+ 10 )