![]() Sometimes you need to report on a more granular level than the day. You can look at this blogpost of Frederik Vandeputte as it seamlessly explains how to create such a date table with DAX. Besides the dates you will probably add extra properties for each date: year, month-names, weekday-names, … Something like this: Such a date table contains at least all the dates in a date range that correspond to your business needs (there is no need to start your date table on Januif your business transactions started in 1990). ![]() Many reports contain dates and therefore chances are you will end up creating one or more date tables in your Power BI model. ![]() Besides the dates you can add extra properties for each date: year, month-names, weekday-names,… But what about hours and minutes? In this blog and video, we’ll show you how to create time tables in Power BI ![]() In a previous blogpost, we already explained how to make a date table in Power BI with DAX. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |