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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ErickBorgesV4
Regular Visitor

Sum data from 2 unrelated tables (key dates)

I have 2 tables, both have values ​​separated by dates, I need to add these values ​​by the dates shown.
They do not have relationships in common, but are related to the dCalendar table.

I tried to create a new table and use LOOKUPVALUE to generate the 2 values ​​in a table and add them up ,but it still gives an error when the key provided has the date value

I would like to know how can I add both values ​​and separate them by dates

 

ErickBorgesV4_0-1664297764040.png

 

The value highlighted in red would be the value that I must add, the value in blue would be the relations with the dCalendar table

 

 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@ErickBorgesV4 , you can join both tables with date table and then display their measure with columns from a common date table

 

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@ErickBorgesV4 , you can join both tables with date table and then display their measure with columns from a common date table

 

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors