Forum Discussion
power query
Hi pchazirakis ,
Are their column types Whole Number or Decimal Number?
I have a simple test on my side, everything works fine. My PBI version is the lastest one——Version: 2.102.845.0 64-bit (February 2022)
Could you please share me with your CSV or pbix file after removing sensitive data to help us clarify your scenario?
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello thanks for all your help I'm not very familiar with coding
my goal is from multiple CSV files with the below configuration to collect the second column make it vertical and make a table with the above values
I have made it to create the table but the numbers are not recognized the decimal point is deleted, the issue is that if the number is "0.014" it is transferred as "14" to the table if the number is "1.4" it is transferred as "14" and etc.
I need a step to replace the "." with "," in all the CSV files. I mast mention that the "," is used to separate the columns
below I have the data from the CSV file :
start of CSV file
Test Name,MANUAL_107
Test Start Time,09:14:49 AM
Mass Average [mg/m3],0.036
Mass Minimum [mg/m3],0.033
Mass Maximum [mg/m3],0.039
Elapsed Time [s],Mass [mg/m3],Alarms,Errors
10,0.036,,
20,0.037,,
30,0.039,,
40,0.039,,
50,0.038,,
60,0.037,,
70,0.036,,
80,0.035,,
90,0.034,,
100,0.033,,
110,0.034,,
120,0.035,,
130,0.035,,
140,0.035,,
150,0.038,,
160,0.037,,
170,0.035,,
180,0.035,,end of csv file
the result I want is a table like
