Add string text to end of measure DAX

[Anonymous]

Hi Experts

Is it possibel to add the letter d to the end of the following measure so the end expected result is 23d 

measure

Avg. Time = AVERAGE(avgtime_case_close_by_country[avg_days])+0

[SamInogic · Accepted solution]

Hi,

You can achieve this by below DAX Expression, 

Result = CONCATENATE(CONVERT(AVERAGE('Table'[Values]),STRING),"d")

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Kieran_Ultra_23]

Avg. Time = 

var Avg_Time = AVERAGE(avgtime_case_close_by_country[avg_days])+0

var Text_Time = Fromat(Avg_Time, "General Number")&" "&"d"

return 

  Text_Time

Hopefully this helps @Anonymous 

[Idrissshatila]

Hello @Anonymous ,

Try this 

measure

Avg. Time = AVERAGE(avgtime_case_close_by_country[avg_days])+0  && "d"

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin