Conver SQL database date format

[Anonymous]

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

[Anonymous]

Hi DM,

thank you for your time...

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

[VahidDM]

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 

[Anonymous]

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