Forum Discussion

ahsanlhcgov's avatar
ahsanlhcgov
Helper III
9 years ago
Solved

create a new column using values from another column and measures.

I am trying to create a new colum which shows the same values as "ThisYearBS" but also has a filter where I can insert value from a measure(which I have created). 

 

 

 

RowTitle is a concatinated colum of two colums ROW and Title. What my goal is that where ROW = 8 insert value from a measure X. otherwise just copy the exact value from the colums ThisYearBS.

 

Column = IF(vBIFinancialLayouts[ReportRow] <8  , vBIFinancialLayouts[ThisYearBS] ,[Total])

  

gives an error Function 'CALCULATE' is not allowed as part of calculated column DAX expressions on DirectQuery models.