Forum Discussion

milomilo2020's avatar
milomilo2020
Frequent Visitor
4 years ago
Solved

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"...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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