Forum Discussion
Returning value from Table A if Table B condition meet Table A
Hi all, I am new to PowerBI and currently developing some dashboard by facing some issue. I have 2 tables - namely historical_data and current_weekly_data The historical_data consist of 3 colum...
amitchandak
Super User
Super Userlaw_90 , You can create a new column in dax like
in current week table =
var _cnt = countx(his, his[issue Name] = curr[Issue Name] && his[Open Date] < curr[Open date]), his[Issue name])
return
if(not(isblank(_cnt)), "Remain", "Newly Added")
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8