Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
CuriousGuy001
Helper I
Helper I

Correct Way to Fill out Date

Hi everyone,

I was wondering what is the correct way to populate the date format for Excel in order for PowerBI to make a good relationship from Calendar table to the Date of the Excel Worksheet. Below is how I make my date table in Excel,

CuriousGuy001_0-1722260719556.png

 

Whenever, I connected with multiple _facttables, [Above the image is one of them], wont work properly if I connect to the Calendar table, 

 

CuriousGuy001_1-1722260892432.png

 

CuriousGuy001_2-1722261032466.png


Any recommendation to improve my experience using PowerBI, I would greatly to open to hear. Thank you!

2 REPLIES 2
CuriousGuy001
Helper I
Helper I

Thank you I found my answer!

ryan_mayu
Super User
Super User

have you changed your date column to Date type in powerbi?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.