Скачать или смотреть PowerBI in 3 minutes: Power Query - Date manipulation

You can use the Data Analysis Expression (DAX) functions CALENDARAUTO() or CALENDAR() to build your common date table. The CALENDAR() function returns a contiguous range of dates based on a start and end date that are entered as arguments in the function. Alternatively, the CALENDARAUTO() function returns a contiguous, complete range of dates that are automatically determined from your dataset. The starting date is chosen as the earliest date that exists in your dataset, and the ending date is the latest date that exists in your dataset plus data that has been populated to the fiscal month that you can choose to include as an argument in the CALENDARAUTO() function.

Please find the link below to Know about Dax expression of date column.
https://sliceup.co.uk/powerbi-dax-exp...

Enjoy this video and leave your valuable feedback. To know more about us, please visit our website.
http://sliceup.co.uk/