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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
milomilo2020
Frequent Visitor

Calculated column filtered by Date from another table

HI, I have this calculated column in a table:

 

 

Calculated column = 

var total_nonbreaches = 
CALCULATE(
    DISTINCTCOUNT(Issues[Key]),
    Issues[Time to first response: Breached?] = "false")

var total_breaches = 
CALCULATE(
    DISTINCTCOUNT(Issues[Key]),
    Issues[Time to first response: Breached?] = "true")

var total = total_breaches+total_nonbreaches 
var final = IF(DIVIDE(total_nonbreaches,total) = 0, 1.00, DIVIDE(total_nonbreaches,total))
 return 

final

 

 

 

The "Issues" table (Fact table) is connected to this table by "Company Code" and also has a "Date" column.

I need to use this "Date" column from "Issues" table to filter the Calculated column when I put it on KPI's.

 

So my goal is to add this "Date" filter into the DAX, so when I create a KPI with the Calculated column, I can filter by "Date"

milomilo2020_0-1649166486212.png

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@milomilo2020 , if you need to join on two-column, then you should create concatenated column both side and join

 

key  = [Company] & "-" & format([Date], "YYYYMMDD")

 

But you need move data from one table to another you can use

new column in table 1  example

sumx(filter( Table2 , Table1[company] = table2[Company] && Table1[date] = table2[date] ), Table2[Value])

 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@milomilo2020 , if you need to join on two-column, then you should create concatenated column both side and join

 

key  = [Company] & "-" & format([Date], "YYYYMMDD")

 

But you need move data from one table to another you can use

new column in table 1  example

sumx(filter( Table2 , Table1[company] = table2[Company] && Table1[date] = table2[date] ), Table2[Value])

 

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors