Forum Discussion

bramos88's avatar
bramos88
Frequent Visitor
8 years ago
Solved

Calculating two values with one month difference

Hello everyone!   I'm having some trouble with calculating the division of two sums with one month difference between them.   Here's what I want to do: I have two columns, A and B. MEASURE = SUM...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    This data is not well structured.  Using the Query Editor, we should right click on the Date column and the right column and then unpivot the other columns to convert your dataset into a 4 column one.  Once that is done, one can easily use the Date/Time Intelligence functions to get the growth over the previous month/year by writing simple measures.

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

Hi bramos88,

 

Please provide sample data to illustrate your desired output. If possible, post an image which shows your expected result.

 

Regards,

Yuliana Gu