Forum Discussion

CSPedrao's avatar
CSPedrao
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 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
Need Help
  • FreemanZ's avatar
    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

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    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

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

    • CSPedrao's avatar
      CSPedrao
      Regular Visitor
      1 year ago

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