Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
So, here is my problem at the moment:
I have a table reading data from a csv file coming from an email daily. The column names might keep changing day today and I need to apply a multiplier to the values when the column changes (e.g. in this case, the data under MWh should be multiplied by 1000). How can I separate these tables based on two types of columns? or how can I apply this calculation only when the column is one of these two types? the number of rows every day is the same (24 rows) I want to make this in Power Query not DAX. Many thanx
Solved! Go to Solution.
Hi @Alirezam ,
1.Split column by custom delimiter
2.Use fill down in both columns
3.Add the following custom columns
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Alirezam ,
1.Split column by custom delimiter
2.Use fill down in both columns
3.Add the following custom columns
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do you have individual columns per location? You will want to avoid that.
You can split the column with the kWh/MWh and then fill down on the second column.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
6 | |
5 | |
5 | |
5 |
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |