Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to Solution.
You may try Unpivot Columns in the Query Editor or use UNION Function in DAX.
You may try Unpivot Columns in the Query Editor or use UNION Function in DAX.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |