Attempting to create a Calendar from date data like the tutorial.

[LPEquestrian]

Hey All, 

Today is my first day using POWER BI , having followed the tutorial i have uploaded my personal data needed which contains warehouse based data on picking products for delivery on certain days from 01/01/2022 - 30/04/2023. Its probably a basic question with a simple answer...

Having followed the tutorial where i create a DAX measure using the command.

Calendar = CALENDAR(DATE(2022,01,01),DATE(2023,04,30))

But when I hit the check mark to create the separate unit in the Data field, it simply adds it to the already existing data that I imported.

All i am trying to do is replicate the tutorial so i can start compiling the data into graphs using the Date as my splicer source.

Any Help?
Cheers,
Lewis

[Ritaf1983 · Accepted solution]

Ho @LPEquestrian 
First of all, good luck.
You need to produce a calendar table and not a measure if you want to use the date model.
Here is a link to an in-depth explanation, complete with construction instructions.
https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query
In order to build a correct model, this is one of the most important topics to study.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[LPEquestrian]

Absolutely right, this was just an oversight on my half, i kept choosing new measure not new table. Thank you very much!

[Ritaf1983]

It was my pleasure to help 🙂