Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi 

 

 Create a one variable and insert a date function and then convert the format(Date/Month/Year) according to your requirement in the Power BI.

 

 

Regards

Rohit

cham's avatar
cham
Post Patron
7 years ago

Do I need to add a column an put a "format" function in the report?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello Cham,

     

    Yes.please put date fundtion and mention in which format you required.

     

     

    Regards

    Rohit

    • cham's avatar
      cham
      Post Patron
      7 years ago

      I export CSV file into Power BI. But some dates are showing as Error. Can I know the reason for that?

       

      Also is this formula correct? Date = FORMAT(Sheet1[Date],"dd""mm""yyyy")

       

      This is not working for me

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi cham 

        This formula should be correct.

        Date = FORMAT(Sheet1[Date],"dd/mm/yyyy")

        It is a DAX formula used in a calculated column.

         

        Is the column with error your original data or the modified data with any transformation?

        Could you share me with data in your excel for analysis?

         

        Best Regards
        Maggie