Database structure help

[afabiano]

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

[v-chuncz-msft]

@afabiano,

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

[Anonymous · Accepted solution]

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]

Phenominal - thanks!

[Anonymous]

@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