Forum Discussion

idontexist's avatar
idontexist
Helper I
8 years ago

Calculate several numeric values

Hi guys,   I need to calculate values like the following:     Plan Fact New measure   15       15       15       15       15 15 15   15       15   ...
Need Help
idontexist's avatar
idontexist
Helper I
8 years ago

Zubair_Muhammad

 

It's plan for store for all days in month.  Table "plan" contains 3 columns: date, store code and value. Value already calculated before downloading in live cube, so it's just number.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi idontexist,

 

Can you share the pbix file please? The relationship between two tables could affect the result.

 

Best Regards,

Dale

  • idontexist's avatar
    idontexist
    Helper I
    8 years ago

    Hi, v-jiascu-msft

     

    i can do that, but you will not be able to see anything, as it's connected to live cube. And i don't have rights to grant you access.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi idontexist,

       

      As far as I know, we can't create a measure in the mode live to SSAS cube. Did I miss something?

       

      Best Regards,

      Dale

      • idontexist's avatar
        idontexist
        Helper I
        8 years ago

        v-jiascu-msft

         

        We can't create new columns. But new measures we can.