Dax Query view - date format contains time

[CSPedrao]

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 working, can anyone advise how I can format the date to '"dd/mm/yyyy" so that it exports it without time?

Many thanks

DAX query 

DEFINE

    VAR __DS0Core =

        SUMMARIZE(

            'Missed_Bin_Attributes',

            'Missed_Bin_Attributes'[UPRN],

            'Missed_Bin_Attributes'[ServiceCode],

            'Missed_Bin_Attributes'[Status],

            'Missed_Bin_Attributes'[Date Requested],

            'Missed_Bin_Attributes'[Date Closed],

            'Missed_Bin_Attributes'[Name]

        )

EVALUATE

    __DS0Core

[lbendlin]

Why? Power Automate works on Datetime as well, as does Power BI.  "Date"  is just a format. not a data type.

[CSPedrao]

@lbendlin I think that you have miss understood me but thank you for your comment anyway

[FreemanZ · Accepted solution]

hi @CSPedrao ,

try like:

DEFINE

    VAR __DS0Core =

SELECTCOLUMNS(

        SUMMARIZE(

            'Missed_Bin_Attributes'[Date Closed] ),

       "Date Closed", 

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

)

EVALUATE

    __DS0Core

[CSPedrao]

@FreemanZ Thanks for your advice, it worked 🙂