combinevalue

2 Topics

Combining measures from different tables
Hello, I have one table named CV_BPC_BRIDGES_R4_ACT where all actual financial data are flowing, from which i created a measure " PY Actual Net Sales" which calculates Prior year actual net sales. I have also one more table CV_BPC_BRIDGES_R4_ACT (since data are flowing from different system) for all Current year + Forecast financial data, where i have created a measure "CY Actual Net Sales". Is it possible to create a measure that will combine these two measures? Of course, it should be dynamic, as the initial measures based on the user`s selection for quarter & country (this is managed through slicers) Thank you in advance.
Solved
Palikaros
3 years ago Place DAX Commands and Tips
777Views
0likes
2Comments
Concatenate a field within IF/SWITCH statement
Hello Everyone, I'm new to Power BI. I have created a new column in my report using this SWITCH statement to group Institutions based on the below conditions. What I want is Concat "Control Group1" with INSTITUTIONS[NAME] within the SWITCH statement. Tried Using CONCATENATE and COMBINEVALUE functions as well as below method. All of those gives me " Error Message: OLE DB or ODBC error: [Expression. Error] We couldn't fold the expression to the data source. Please try a simpler expression.." Error. I'm using Direct Query mode in My Report. Appreciate If anyone can suggest me a method to concat a string with Table[ColumnName] within a SWITCH Statement INSTITUTIONS GROUP= SWITCH ( TRUE (), INSTITUTIONS[ID] = "d3a2efa8" || INSTITUTIONS[ID] = "721be8893","Control Group1" & " - " & INSTITUTIONS[NAME], INSTITUTIONS[ID]="729dbb5a-" || INSTITUTIONS[ID] ="b7ea8f29" || INSTITUTIONS[ID] ="6d85fa58" || INSTITUTIONS[ID] ="1df7d3ed","Control Group2","Control Group3") Thanks RushiS
Anonymous
5 years ago Place DAX Commands and Tips
1.9KViews
0likes
1Comment