Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago

Add measures to a table

Hi,

 

I have different measures. for example

Measure 1 = X

Measure 2 = Y

Measure 3 = Z

 

How can I create a new table with 2 columns as follow:

 

name          Value

M1              measure1

M2              measure2

M3              measure3

 

Thanks,

 

Need Help

5 Replies

  • BeemsC's avatar
    BeemsC
    Resolver III
    8 years ago

    Create a new table usingt "Enter data" and make one column with M1, M2, M3 etc.
    Then make a new column and use if statement for each value.
    So If(Column1 = M1;Measure1;"") etc.
    didnt actually test this.
    Let me know if it works

    • abukapsoun's avatar
      abukapsoun
      Post Patron
      8 years ago

      negative. I cannot select the measure in the if statement.

      • BeemsC's avatar
        BeemsC
        Resolver III
        8 years ago

        Try create the measures with variables ? maybe it can work like that