Forum Discussion
Adding calculated column to date table
Hi, I've got a dimension date table with a dateid (yyyymmdd) and a currency table with fields: dateid, currency, value. I want to add 4 columns to the date table, 1 for each currency with the v...
Kedar_Pande
Super User
Super UserYou can't create calculated columns that reference tables from different semantic models. This is a hard limitation in Power BI.
The only solution is to merge the currency values into your date table during data transformation using Power Query, before the data loads into the model.