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
HenryJS
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

 

 

Capture222.JPGCapture2222.JPG

 

 

 

Export Actions

 

UserNameActionRefActionNameActionDate
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
1 ACCEPTED SOLUTION

Try

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

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@HenryJS,

Remove time stamp from ActionDate before joining to date table

 

ActionDate 1 = [ActionDate].Date

@amitchandak returned below error

 

Capture.JPG

@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.

Try

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

Helpful resources

Announcements
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.