Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |