Forum Discussion

team_steve's avatar
team_steve
Advocate I
9 years ago

Multiple dates tables

Hello, This is probably a silly question but I cannot find a definiative answer so here goes.   I have an orders table containing a Date Entered field, and a Date Invoiced field (also Date Require...
Need Help
team_steve's avatar
team_steve
Advocate I
9 years ago

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.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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