Forum Discussion

matskah's avatar
matskah
Frequent Visitor
1 year ago

Convert String to DAX Formula

Hi everyone,   I currently have a very basic semantic model containing a centralized fact-table with call-data. As this fact-table is used in multiple applications I want to achieve the following:...
matskah's avatar
matskah
Frequent Visitor
1 year ago

Hello dharmendars007 ,

thanks for your effort and your reply, but that was not what I meant. Sorry if I was not specific enough here.

 

I already have a table in my PowerBI-Model.

This table consists of two columns.

  • Title: Contains the title of the measure (to be)
  • Formula: Contains the DAX-Formula for the measure (to be)

 

Basically I want the following:

I now want to create a measure that gets its information on how to calculate from a specific field value out of table column "Formula".

 

Example:

I have an entry in my "FormulaBook"-Table that has the value "#Calls" in the title column

So I want to create a measure in PowerBI that is called "#Calls" and the information on how it is to be calculated can be found in the corresponding "Formula"- column from the FormulaBook-Table.

 

How can I write my DAX-Formula for "#Calls", so that it interprets the Value from the "Formula"-column as an actual DAX-Formula and not just as a string-value?