cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rup10
Resolver I
Resolver I

Conversion of date (data type) to text through dax expression

Hi,

 

I need to convert from date to text/string format through dax expression/measure and i tried two functions datevalue and format but these arent working.

Below is the measure for your reference : 

Measure = IF(ISBLANK(COUNT(TABLENAME(COLUMNNAME))=0,"CALLS",)),COUNT(TABLE(COLUMN NAME(WHICH IS IN DATE FORMAT))

 

Can someone please help me with this.

Thanks in advance

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Rup10 , date to text is simple

 

format([Date], "YYYY MM DD" )

for also give MMM DDD etc

 

 

refer for the doc

https://docs.microsoft.com/en-us/dax/format-function-dax



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @Rup10,

I think you can try to use the format function will help for text conversion.

In addition, what type of format you wanted? If you are confused about the coding formula, can you please share more detailed information to help us clarify your requirement?

How to Get Your Question Answered Quickly
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User IV
Super User IV

@Rup10 , date to text is simple

 

format([Date], "YYYY MM DD" )

for also give MMM DDD etc

 

 

refer for the doc

https://docs.microsoft.com/en-us/dax/format-function-dax



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors