I am new to PowerBI, please excuse the newbie question.
I have a report pulling information from my VFP ERP system. What I don't know how to do is this:
The stock values for items we sell by size. There are 4 tables feeding the information for the report. One database has the style info and contains the stock amounts under columns named Stk1, stk2 ,stk3, etc. One of the columns has the size scale code, and another table has the size scale code with the sizes for each code.
I would like to show the size instead of Stk1, stk2, etc. I would like to see S, M, L as the headers.
How do I accomplish this? Any help would be most appreciated.
Remove the skttot column. Select the first 2 columns, right click on the heading and select "Unpivot Other Columns". In the Query Editor, you can now join this table with the other one which has the sizes.
We want to help you but your description is too vaugue.
Please write it again clearly.
Provide example input data as table text (not a screen print) so we can import the data to build a soution for you. Also provide the example desired output, with a clear description of the process flow.
Dont share private data. Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.
You will get a quick response if you put time and effort into writing clear problem descriptions.
Vaugue descriptions waste your time and ourtime.
Look foward to helping you when the above information is forthcoming.