Forum Discussion

Regular Visitor

1 year ago

Solved

Dax Query view - date format contains time

Hi, I've created a Power automate flow that has a Dax query to extract data from Power BI, however the date is being exported with time. I tried using the format on the Dax query but it's not worki...

Need Help

FreemanZ
1 year ago
hi CSPedrao ,

try like:

DEFINE

VAR __DS0Core =

SELECTCOLUMNS(

SUMMARIZE(

'Missed_Bin_Attributes'[Date Closed] ),

"Date Closed",

FORMAT([Date Closed], "YYYY/MM/DD)

)

EVALUATE

__DS0Core