Forum Discussion

NLeelakrishna's avatar
NLeelakrishna
Frequent Visitor
8 years ago

How to change format for date field with DAX expression while get data as direct query in power BI

Hi,   I want change format for date with DAX expression while direct query in Power BI. I have tried with format function in DAX but getting error like "Function 'FORMAT' is not allowed as part of ...
Need Help
JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
8 years ago

Hi NLeelakrishna,

 

You can try just extracting each individual part and casting it to a date. So if you want a MM/DD/YYYY format, try:

 

= MONTH(Date[date])&"/"&DAY(Date[date])&"/"&YEAR(Date[date])

 

Hope that helps!

kskarthick's avatar
kskarthick
Icon for Advocate I rankAdvocate I
8 years ago

Hi Joho,

 

Thank you for the idea, we will try and let you know.

 

Without DAX is that possible in the data modeling, Like custome format like (dd/MMM/yyyy).

  • JoHo_BI's avatar
    JoHo_BI
    Icon for Responsive Resident rankResponsive Resident
    8 years ago

    As far as I know it get taken from your local DateTime settings and there's no way to override it without DAX

    • kskarthick's avatar
      kskarthick
      Icon for Advocate I rankAdvocate I
      8 years ago

      Thank you Joho for your confirmation.