Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous54000
Frequent Visitor

comparing 2 different measures on monthly basis but from 2 unconnected tables

Hello.
I built 1 measure (Deposits P&C) and use it on 2 table visuals :
-current forecast
-previous forecast

Anonymous54000_1-1690374449154.png

 


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 !


1 ACCEPTED SOLUTION
Syk
Super User
Super User

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

View solution in original post

2 REPLIES 2
Anonymous54000
Frequent Visitor

now working perfectly, thax a lot !

 

Syk
Super User
Super User

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.