Forum Discussion

idontexist's avatar
idontexist
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
8 years ago

Hi Zubair_Muhammad

 

But if value is not only one? It could be several values.

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

idontexist

 

is the Plan Column aggregated in some way?

  • idontexist's avatar
    idontexist
    Icon for Helper I rankHelper 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
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Helper I rankHelper 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.