Forum Discussion

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

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Chasm,

       

      Please cross the check the function formula and data appearing the excel sheet .whehter it is same format as above or different format the date is appearing..

       

      Regards

      Rohit