Forum Discussion
Transform Excel column formulas to Power Query query (or Power BI)
hi, Anonymous
What is your data structure in power bi?
In your data structure of excel, "Site" and "Period" is defined by the formula, but it should be column header.
It couldn't be defined by the formula, is it a "value" not the column header in power bi?
And how to get D1,A3 or G1,B3 , are they in the same table together in power bi?
The logic of your formula is simple, and please share your sample pbix file or some screenshots of data view in power bi.
Best Regards,
Lin
Hi Lin (@v-lili6-msft),
I've attached the Excel file this originates from. I'm trying to take this to a Power BI (or Power Query) solution . This shows the file with the computed columns I'm looking to move to Measure or solution that will utilize Power Query to create these columns rather than doing it in Excel once the 'export' tabs have been combined. I also need to remove the rows that contain the text 'Site:' and 'Period' after the (in this case calculated columns) are created. In other words, the values for 'Site:' and 'Period:' are used to create the cacluated columns and then the rows that are used to create them would be removed. So the values for Site and Period would need to be copied from their corresponding row and not just referenced. Thanks for your help!
vr,
namdron
hi, Anonymous
For your case, I suggest you do it in Excel.
If this is raw data, how do you import them into power bi?
just import table "tool"? if so, the sort of column value may be changed, and how to match the 'Site:' and 'Period:' for the raw data? Your raw data structure is irregular, for your special case, It's very easy to implement in excel but is very troublesome in power bi.
Best Regards,
Lin