Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi,
I need to show a Clustered chart with date column and planned values from one table and date and planned value from other table,
Is there any way to do so,
Or, How to Merge 2 tables, Date and planned with Date and Budget columns
Thanks in advance
@Ahmad_16 , There is no need to merge tables. Create connection between tables and you can proceed with the visual in a normal way.
it doesn't work with this, there is no key field, and even the dates are not the same.
need to merge them in one table first
@Ahmad_16 Go to transform data/power query. There in combine group there is an option to merge queries/tables.
User | Count |
---|---|
91 | |
74 | |
71 | |
58 | |
55 |
User | Count |
---|---|
41 | |
38 | |
34 | |
32 | |
30 |