Forum Discussion
Calculation with the date format
Hello,
I have a column with they format DD/MM/YYYY hh:mi:ss and other column with a value at that date&time. so for example:
Date Value
30/03/2012 09:00 100
30/03/2012 10:00 200
31/03/2012 09:00 100
I would like to see this in my dashboards:
30/03/2012 300
31/03/2012 100
I changed in modelling the format to dd/mm/yyyy but the data are presented like this:
30/03/2012 100
30/03/2012 200
31/03/2012 100
What can I do?
Anonymous
Try to create a calculated column with following formula in Reading table. And change the data type to Date.
Column = DATE ( YEAR ( Reading[Interval Date] ), MONTH ( Reading[Interval Date] ), DAY ( Reading[Interval Date] ) )
In the table visual, use above column instead of Interval Date.
Best Regards,
Herbert
8 Replies
Anonymous
When you create the Table visual in the canvas, the values can be summarized as below.
Best Regards,
HerbertAnonymous
Please try to change Data type from Date/Time to Date.
Best Regards,
Herbert