Forum Discussion
Data Modelling - matrix visualization - weekly/monthly/90 day view
I didn't really understand the lookup range concept. Kinda new to Dax and all. So I went ahead with the date table route. Created a datetable and linked it to my data table. Have some basic visualization set up in a matrix. For my company, most of the start and end dates have times from 8:30 am - 5:30 pm. If I want to set up start and end dates along with their times like shown above, should I create a date table with hourly intervals for each day ? Thanks for your help Greg_Deckler
Hi Anonymous,
I do not so recommend you accurate mapping all dates with hour intervals, it will generate huge amount of records and affect the performances.
In my opinion, you can create a expand table on date level to mapping raw table records and a standalone time table(it does not have any relationship to other tables) for further dax formula calculation.
You can take a look at the following link to create a calculated table with expanding records which generated from raw table date fields:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng