Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Purpose of "Mark as date table" in Power BI


My "orderdate" column in fact table is not contiguous, so I created  "Date" table using dax. I calculated YTD using date column in "Date" table. YTD shows correct value without even using "Mark as date table". I want to know the purpose of "Mark as date table".
Can anyone help with this?


Community Champion
Community Champion

Hi @Keerthika ,


I am sharing this link for your reference.

Thank you.

Hi @mussaenda ,

Thanks for the reply. I also referred to the same link. I followed the same procedure as in the link, but I couldnt find any difference. YTD works fine even without using "Mark as date table" option. Can you explain the purpose of "Mark as date table"

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors