How to list the days between a start date and an end date

[Anonymous]

I have a table with a start date and end date and other information.

I wanted to show every day between the start and end dates.

Can I do this in DAX? 

[HotChilli]

The end date of the second line is wrong (2020).

-----

In Power Query, add a new column like this:

{Number.From([START_DATE])..Number.From([END_DATE])}

then expand the new column (from the header) to new rows .

Then change the column type to date.

Good luck.

[Anonymous]

Hi, HotChilli

Thanks for the help but i am in directquery data connectivity mode via oracle database and adding column only allows in import mode.

Is there a way to do it by directquery? Probably not, right? I would have to do something similar in the query from database?