In M query how to get minute part from UTC

[Anonymous]

Dear all,

Please help in getting Minute's part from UTC date. I tried for Hours it worked but not for Minute's. M Query which i used is below

ReportAlert = var _Hours = FORMAT(UTCNOW(),"HH")
var _minutes = INT(FORMAT(UTCNOW(),"MM")) 

return _Hours - Working i'm geting hour part
return _minutes - Not working it's giving month instead of minute's, here I'm expecting minute's.

Thanks,

Suman

[gooranga1 · Accepted solution]

Hi @Anonymous

that looks like DAX not M you are wrting with. Have you tried this

var _minutes = minute(UTCNOW())

[Anonymous]

Thanks that worked