Forum Discussion
Multiple dates tables
out of interest what is the purpose of bringing the date dimension in is it for a specific calendar or is there something you need it for? on date fields power bi automatically creates a invisible date table which allows for generic date functionality i.e. it provides a hierarchy etc. If you aren't looking for any specific functionality except the use of a typical hierarchy i would say as long as your date type is date, you should automatically get some date functionality - when you drag the date on to your object you should be able to switch it between the date value and the hierarchy values.
I've not really used the built in date, though I think I've the heirarchy kick in when I display a date field on a table visualisation for example. The Dates dimension I bring in breaks down the date into day, month year as you would expect. Also day of week, week number, first date of the week and month, last date of month. Indications of whether a date should be included in YTD, MTD and WTD calculations. Rolling 3, 6 and 12 month periods.
I think the same calculations can probably be done with DAX but I'm not sure what the best method is.
Hi team_steve,
Based on your description, I am unable to reproduce your scenario, could you please share your .pbix file and list the expected result clearly, so I can analysis furtherly. Thanks a lot.Best Regards,
Angelia
