Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Working with LIVE data (Analysis Services)

HI everyone, I have one question and hope you can help me.

Now I am working with live data, and I have one matrix table wich one should shows "CFYTD" and "PFYTD".

But I can't show neccessary data (look in pictures below).

There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous

 

Here are what I am using 

CFYTD and PFYTD are measures.


Live data don't allow "edit query", "enter data"... or use "new column", and I have only measurs.

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    >>There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous.

     

    I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? Do mask sensitive data before uploading.

     

    Best Regards,

    Amy

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    >>There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous.

     

    I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? Do mask sensitive data before uploading.

     

    Best Regards,

    Amy