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.
Hi Good Day,
I have a proper data set that involves three tables viz,
1)DataInvoice
2)Points
3)Factor
I need a visual that shows Date column from Datainvoice,units column from datainvoice table multiplied with value column from Factor table.
But the above can happen with few filter criteria as below
1)Date column from Datainvoice should fall between Start and End date of factor table and then return corresponding Value
column
2)while filtering the above we should make sure that DBName-point-id from datainvoice should match DBName-point-id of
points table which inturn looks for DBName-Utility in factor table and picks up the VALUE column
This is how the relationship looks:
I want the output to look like below in a visual
Looking forware to your response
Thanks in advance
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 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |