table with dynamic values

[Anonymous]

My power bi data source is a tabular model i prepared. In a particular table which i'm fetching, i need the values of 2 columns to be dynamic and be calculated based on a separate table that i'm getting every week. Is it possible to code somehow so if i can make the valyues dynamic, the values in those columns get updated (in the report only and not in the model) by those values every week.

[Anonymous · Accepted solution]

Hi @Anonymous

Yes, its posisble.

Assuming that ColumnA in Table 1 should be dynamic based on Column B from Table2.

You need to make sure the relationship is set in the model. And you can define ColumnA using DAX to refer Table2.ColumnB using RELATED().

Thanks
Raj