Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/
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/
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
Hello @Anonymous ,
Try this
measure
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |