Forum Discussion
Impactful IndividualTransform facttable into a customized List with own description names
Hi, Applicable88
Please check the below picture if it is what you are looking for.
Please correct me if I am wrong.
The top visualization is when you arrange the columns and measures like below
The bottom visualization is when you arrange the columns and measures like below.
Please check the link down below,. I have fix it.
https://www.dropbox.com/s/pn9klpzme3iu61l/SampleData.pbix?dl=0
Thank you very much.
Impactful IndividualHello Jihwan_Kim,
Sorry I have no sample data. But the example I did already is close to that.
The main facttable that I'm loading from is the table on top:
I want the table become like this:
To your question no.1 : Only the status will tell me if the order is shipped or in process. The date is only referring to the moment when I checked data.
to question no.2: I don't know exactly what you mean, but yes... I want only two rows, which are kind of my measure for the count of "shipped" orders and the second one "in progress" orders.
Hope that was clear. If not I can try to create sample Data and give you the preferred outcome that I want.
Thank you.
Super UserHi, Applicable88
Perhaps I don't understand your question well, but you mentioned that you did not show the Code Column here. Is it OK to see your sample data with the Code Column showing orderdates and shipdates ?