How to select Column fields as drop down filters, and calculate measures dynamically

[RustyNails]

Hi All, I have a requirement that was satisfied with Tableau but I'm having difficulty porting it to Power BI.

The request is for a user to select any two date column fields they want from a dropdown list, and based on their selection the result should give you an average of date difference. In Tableau I was able to automatically select the fields I wanted, and based on my selection I could do any calculations between them.

An example of what I'm talking about, here is what the structure looks like (obviously there's ton more, but this gets the point across)

And here's what the end result should look like

The request is borne out of the fact that we have hundreds of Date fields, and we need a historical trend of averages between them. Is there a way to convert the columns to rows, preferably in the report section? Any help is appreciated.

Thanks!

[v-chuncz-msft · Accepted solution]

@RustyNails,

You may try Unpivot Columns in the Query Editor or use UNION Function in DAX.