topic Convert String to DAX Formula in DAX Commands and Tips

Convert String to DAX Formula

matskah — Wed, 25 Sep 2024 09:50:39 GMT

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:

I would like to create a centralized Formula-Book represented by an Excel-File that can be loaded into multiple applications.

The formula book should look sth like this:

Once I change the formula, the changed are applied in all the Apps that use the formula book.

From there I would like to create a Measure-Table that reads in all the Formulas and interprets these as such.

Somehow I am stuck as I cannot interpret the string as an actual DAX-Formula.

Can anyone of you please help me?
Or do you have any other recommendations?

Thanks in advance!

Re: Convert String to DAX Formula

dharmendars007 — Wed, 25 Sep 2024 12:17:55 GMT

Hello matskah ,

Please navigate to DAX Query section and input the measure as shown as above and you will be able to get all the measures in one place.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

Re: Convert String to DAX Formula

matskah — Thu, 26 Sep 2024 05:51:24 GMT

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?