Skip to main content
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

Post Prodigy
Post Prodigy

Matrix: Date Columns

Hi all,


I have created a matrix with Weeks along the columns. 


Action Name is the rows and a count of 'Action Ref' in the values. 


But the data isn't picking up the date values? Tables are joined Action Date - Date







Export Actions


Jami Thirkettle2748316CV Sent02/12/2019 17:11
Sarah Schofield2747219Email - Password Sent02/12/2019 15:22
Izabela Mylak2747220Create Contact - Manual02/12/2019 15:23
Izabela Mylak2747221Agreement - Accepted02/12/2019 15:23
Katie Peachey2747222Create Contact - Manual02/12/2019 15:25
Dominika Roman2750263Not Progressing02/12/2019 17:21
Dominika Roman2750264Not Progressing02/12/2019 17:21
Dominika Roman2750265Not Progressing02/12/2019 17:21
Dominika Roman2750266Not Progressing02/12/2019 17:21
Dominika Roman2750267Not Progressing02/12/2019 17:21
Alan Freer2751110New Job02/12/2019 20:12
Alan Freer2751111Considering02/12/2019 20:14
Alan Freer2751112Considering02/12/2019 20:14


ActionDate 1=date(year([ActionDate]),month([ActionDate]),day([ActionDate]))

View solution in original post

Super User
Super User


Remove time stamp from ActionDate before joining to date table


ActionDate 1 = [ActionDate].Date

@amitchandak returned below error



@HenryJS you should change the data type of Action Date column to date and that will do it.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.


ActionDate 1=date(year([ActionDate]),month([ActionDate]),day([ActionDate]))

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.