Step-by-Step guide on Date table

[adriansuteu]

Hello.

I am new to Power BI and I can't make the date table work the way it is supposed to be and therefore I can't use Time intelligence. I have experience in Dynamics CRM, Access and Excel and I get the basics. But it seems like I am missing something and it doesn't work.

I have downloaded the Date table from azure marketplace (https://datamarket.azure.com/dataset/boyanpenev/datestream) but it didn't work that way neither. It just doesn't get my calculation right or it doesn't get me the options to filter by date/month/quarter etc.

I think that I don't get the relationships right, although I have created a many-to-one relationship from the field OrderDate(format as date) to the field Date(format date from the Date table). More than one order can be placed on the same day.

Can you please tell me if there is a step-by-step guide with all the required steps? So that I will be able to spot my mistakes and correct them.

Thanks,

Adrian

[HarshaliPatel]

Hey Ankit,

I think these articles on Power BI would help you How to create a date table in Power BI in 2 simple steps and How to Download & Install Power BI in 7 Simple Steps...

[HarshaliPatel]

Hello Ankit,

I think this article will help you solve you problem. How to create a date table in Power BI in 2 simple steps

and How to Download & Install Power BI in 7 Simple Steps

[ankitpatira]

@adriansuteu so that I understood you correctly, you're trying to use Date field in your visuals to be able to analyse by year, month and quarter right ?

[adriansuteu]

@ankitpatira Exactly. I want to be able to compare date from different time-frames. I have used multiple resources to find out how to work with Date table. But they were all vague. Therefore I am missing something and I don't know what.

That is why I would appreciate if you could point me to a resource with a compelte, step-by-step guide (video tutorial or text with images)

[Sean]

@adriansuteu Check out Matt's posts here

http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/

or here

http://www.powerpivotpro.com/2015/03/create-a-445-calender-using-power-query/

Then head on here for Time Intelligence Patterns

http://www.daxpatterns.com/time-patterns/