Forum Discussion

ibrahimsharaf's avatar
ibrahimsharaf
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Getting all dates between 2 dates

Hello guys, I have 2 columns named, start date and end date, I want to create a column which contains all the dates between the after mentioned dates, for example      
Need Help
Show and Tell
Tips and Tricks
ibrahimsharaf's avatar
ibrahimsharaf
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

ImkeF it works, but when I expand the lists, the primary key in my table gets duplicated, so Power BI gives me an error when applying the query, I tried creating a new table, adding a new custom column with the formula you mentoined in addition of the table name besides the column name, but it gives me this error in every row of the created column

"DataFormat.Error: We couldn't convert to Number.
Details:
List"

 

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Not sure if I could follow you here, but the error-message suggests that you are trying to convert a list instead of a number. So is it possible that you haven't expanded the list yet?

     

    Otherwise please share query-code or file.