The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello. I'm trying to create a dashboard that has multiple parameters for 'area workers' that can be used to calculate how long it would take to finish the jobs in a particular area.
For example, If I have the SOUTH area and it has 3 jobs that take 30 minutes and I have a SOUTH WORKER parameter of 3 it would take 30 minutes to finish the jobs.
I believe I can achieve this by being able to create another table that has the distinct AREAS with the 'area workers' parameter value but I'm not able to figure out how to create a column from each of the seperate parameters.
expected output:
AREAS | Parameter Values |
SOUTH | 1 |
NORTH | 2 |
etc | etc |
any help would be appreciated.