topic Re: Conver SQL database date format in DAX Commands and Tips

Conver SQL database date format

Anonymous — Fri, 15 Dec 2023 06:02:26 GMT

Hi Team,

i have trasaction date in SQL dabase and directly connected to power bi.

SQL database format like --Friday, December 01, 2023

i Need required format is --12/01/2023

i have tried this format

Trasaction date = FORMAT(MIN(table[Trasacation date]),"mm/dd/yyyy") , invidually its working fine but while other fileds its showing blank..... after that i have tried to change the format but its showing only text....no other format dropdown

any possible to share feedback

Re: Conver SQL database date format

VahidDM — Fri, 15 Dec 2023 06:28:46 GMT

Hi Anonymous

First, Convert the Transaction Date to Date Data Type:

Converted Transaction Date = DATEVALUE(table[Transaction date])

then Format the Date for Display (Calculated Colum)

Formatted Transaction Date = FORMAT([Converted Transaction Date], "MM/dd/yyyy")

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Conver SQL database date format

Anonymous — Fri, 15 Dec 2023 11:18:18 GMT

Hi DM,

thank you for your time...

While adding the Datavalue its taking only measuare not a table collumn. please share some inputs

Re: Conver SQL database date format

Anonymous — Sat, 16 Dec 2023 08:46:27 GMT

Hi DM,

thank you for your time...

While adding the Datavalue its taking only measuare not a table & column. please share some inputs

how we can achieve