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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
UncleLewis
Helper V
Helper V

Power Pivot Connect To Dim Date Give Incorrect Results

Hi all,

I imported csv files for Jan, Feb, March - 2023 into Power Pivot 22.9M rows.

I joined the data to a data table 1/1/2023 - 12/31/2023 on the data field. Relationship in Model View looks good 1:M.

I was expecting many products for March to show zero and the corresponding products for Feb and Jan to show small integer values 3, 5, 8 a few others.

 

But when I created a Pivot with Products on rows and months on columns - I was surprised to see values for March.

 

One of my co-workers asked what would happen if I removed the Data Table and just use the data from the original csv files. I was surprised this did work and I now see the expected values.

 

Any thoughts on why this worked? I've never seen this behavior before

Thanks,

w

 

 

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.