The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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"
Thanks
Solved! Go to Solution.
@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
@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