Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Stephane,

Thanks for the input.

We have a query, we are not getting the date ranges from 01/01/0001 to 12/31/0099 in the report view.

Kindly guides us haow to resolve this issue.

 

Thanks,

Priyanka 

ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

If all you need to do is have them for a Power BI report, and you don't need to do any date calculations in Power BI, you could convert them to text strings.

 

eg:

 

 

#"Text Dates" = Table.TransformColumns(#"Previous Step",{"Date Column", each Date.ToText(_,"MM/dd/yyyy")})

 

 

In the Advanced Editor of PQ, change "Previous Step" and "Date Column" to the appropriate step and column name as required. And the format to whatever it is you prefer.

 

Above in Power BI