Powerpivot/Dax convert seconds into minutes

[M1donne]

Hi all

I have a table of raw data that comes from my cycle powermeter details various metrics recorded every 2 seconds or so, I want to use the raw data in a powerpivot dashboard but want to change the x axis of my chart to report minutes rather than seconds.....

At the moment the format is as follows...what is the easiest way to convert it to minutes using Dax?

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]0.017[/TD]
[/TR]
[TR]
[TD="align: right"]0.033[/TD]
[/TR]
[TR]
[TD="align: right"]0.05[/TD]
[/TR]
[TR]
[TD="align: right"]0.067[/TD]
[/TR]
[TR]
[TD="align: right"]0.083[/TD]
[/TR]
[TR]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD="align: right"]0.117[/TD]
[/TR]
[TR]
[TD="align: right"]0.133[/TD]
[/TR]
[TR]
[TD="align: right"]0.15

[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Any help would be appreciated, should be simple but I'm not getting anywhere.

Regards

 

[scottsen]

Well, generally you are just going to ... multiply it by 60, but in general, you kind of want to avoid doing that in the power pivot table (as you are duplicating a column of facts, which isn't great for perf).

I would generally do this in a measure: Total Foo := SUM(MyTable[Foo]) * 60

(Measures are called Calculated Fields in 2013). Obviously if you are trying to show an average over some period of time it's vaguely more interesting.