Data Invalid Dimension Bar Chart

[GMellow]

I have date data that looks like the following:

Completion Date

3/1/2021

3/1/2021

3/1/2021

4/1/2021

9/1/2022

12/1/2022

12/1/2022

3/1/2024

3/1/2024

12/1/2024

12/1/2025

12/1/2030

12/1/2035

12/1/2045

When I use this in a bar chart I get invalid dimension. When I use it on a grid chart (as Completion Date)  it works fine.

I've tried the following:

=SUM([Completion Date])

=SUM(distinct[Completion Date])
=MaxString( Floor(Date# ([Completion Date], 'MM/DD/YYYY')))
=SUM(Date([Completion Date],'MM/DD/YYYY'))
=Sum([Completion Date.autoCalendar.Date])

Any help appreciated!

[rubenmarin · Accepted solution]

Hi, using just [Completion Date] as dimension it should work

I dont' know what you want to get doing a sum of dates. Can you upload a simple sample to check?