Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello.
I built 1 measure (Deposits P&C) and use it on 2 table visuals :
-current forecast
-previous forecast
I would like for each month also in a table the difference between current and last forecast.
Problem data from current and previous forecasts come from 2 different tables (each of them with their own date collumns) that I can't really link (no collumn with common unique data could be used).
Is there another way to proceed ? So far all my attempts failed when trying to apply the results month per month.
Thanks !
Solved! Go to Solution.
You need to create a date table to link your 2 fact tables. Then use the date table in your visualizations and you wont need 2 different table visuals.
https://youtu.be/WybnTHDl-AM
now working perfectly, thax a lot !
You need to create a date table to link your 2 fact tables. Then use the date table in your visualizations and you wont need 2 different table visuals.
https://youtu.be/WybnTHDl-AM
User | Count |
---|---|
119 | |
66 | |
66 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |