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
Not sure what i am doing worng here, i want to be able to show a concatentate formula that produce the following output based on certain columns.
Column A= Stembrand (String Polarstem)
Column B= Primaryyearsoutcome (all value are in the format 7.5)
Result in new column should read Polarstem7.50000 (not as per current DAX)
As you can see i have appended four 0000 to the end..
my dax is
EMYEARS = CONCATENATE(Sheet1[STEMBRAND],FORMAT(Sheet1[PRIMARYTOOUTCOMEYEARS],"0000")
Solved! Go to Solution.
Hi @Anonymous ,
Please see the below example.
Thanks
Hi @Anonymous ,
You can use below below DAX column, this will add "0000" at the last
EMYEARS = CONCATENATE(Sheet1[STEMBRAND],Sheet1[PRIMARYTOOUTCOMEYEARS]&"0000")
If the value for PRIMARYTOOUTCOMEYEARS is like 7.55 then above DAX will show the value Polarstem7.550000. If you need exact 5 digits after dot then you need to use below DAX formula
EMYEARS = CONCATENATE(Sheet1[STEMBRAND],LEFT(Sheet1[PRIMARYTOOUTCOMEYEARS]&"0000",7))
If this helps and solve your problem then mark this as solution and give khudos.
Thanks
Hi Sunil
The 7.5 was any example i have values the are 0.0, 1.2, 3.4 and so in primary years how dose the second dax work please.
Hi @Anonymous ,
Please see the below example.
Thanks
excellent
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |