Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HEY all,
I am fetching data at multiple row level and from diffrent tables (3 to be precise) i need to fetch the max and min at the first column level. Please help me in creating both column and measures.
the output visual should be like below :
Help is appreciated 🙂
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
hey Amit @amitchandak , let me re phrase my issue .
1. we are fetching the data from 3 tables to be pricise . After inputting the data and perfoming data moddeling . the input report is PFB .
the aim is to group the data by first column name and find the min and max volume per each category name in column one (such as KIbali ,Jabal Sayeed etc .)
the output should be PFB.
Mine | Gold COG (gm/t) | |
Min | Max | |
Bulyanhulu | 0.34 | 0.41 |
Buzwagi | 0.44 | 0.44 |
Jabal Sayid | 0.48 | 0.51 |
Kibali | 0.55 | 0.65 |
Loulo Gounkoto | 0.69 | 0.83 |
Please note the first column is being fetched by table 1 lets say mine and second column by table name lets say site and table 3 had the numeric data (cutoff colun and recovery column )
You have not received any reply within 5 hours... That means nobody understands what you're asking about. Please refer to this article to know how to get your question answered. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |