Basically I have a column called measure_code in 2 different tables and I want to create a dropdown that contains all the distinct measure_code's from both tables.
I'm sure this is possible but I cannot figure it out.
Any help is appreciated.
I would create an intermediate collection that takes the data from both and then do a distict in teh dropdown based on that. EG:
Dropdown Items equals Distinct(collection Name,Column)
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand