Calculation with the date format

[Anonymous]

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]

Unfortunately this is not what happens to me.

I have the column in format 31/03/2012 09:00. I just went to modelling and I changed format to 31/03/2012, but this is not the original format.

[v-haibl-msft]

@Anonymous

Please try to change Data type from Date/Time to Date.

Best Regards,
Herbert

[Anonymous]

it doesnt work, ithappens exactly the same thing.

[v-haibl-msft]

@Anonymous

Could you please provide your PBIX file to me? You can share it through online file service like OneDrive.

Best Regards,
Herbert

[Anonymous]

Check if you have access to this folder. Thank you!

https://drive.google.com/open?id=0B3W6nmMyLpR9WkxrbGhoMUtWUEE

[v-haibl-msft · Accepted solution]

@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

[Anonymous]

Thank you! It worked!

[v-haibl-msft]

@Anonymous

When you create the Table visual in the canvas, the values can be summarized as below.

Best Regards,
Herbert