Solved: Re: Database structure help

afabiano · ‎10-19-2017

Im sure this can be done but I could use some guidance

I have table with about 40 columns appended from multiple tables. The first column are the dates where an "exceedance" was recorded. What I would like to do is have a single column for all the exceedances next to the date column. I would also like to know which column the data is coming from beside the result. See the current structure below. Anyone think they can help with this? Thanks!

recor

Anonymous · ‎10-19-2017

Load this data into the Query Editor. Select your Date column. Then go to the Transform tab of the Ribbon, and click Unpivot Other Columns. You can also right click on the Date column and get to this option from there.

That should give you what you're looking for.

View solution in original post

v-chuncz-msft · ‎10-20-2017

@afabiano,

By the way, In DAX, you may take a look at the GENERATE Function similar to the CROSS APPLY condition in SQL.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎10-19-2017

Load this data into the Query Editor. Select your Date column. Then go to the Transform tab of the Ribbon, and click Unpivot Other Columns. You can also right click on the Date column and get to this option from there.

That should give you what you're looking for.

afabiano · ‎10-19-2017

Phenominal - thanks!

Anonymous · ‎10-19-2017

@afabiano, if this method worked for you, please consider marking the reply as a solution. That way users will see a green check mark on the thread, and the solution will always stay at the top of the thread.

Cheers,

~ Chris