Forum Discussion

bog12345's avatar
bog12345
Frequent Visitor
8 years ago
Solved

compare rows and time

 

Hi ,

 

I need some help with Dax. 

There are 4 column in my test table as follows:

-ID: every customer have unique ID, every row means one subscription

-start of service: The start of the subscription

-end of service: the end of the subscription

-number of service: it has 3 possible value: 1 if the customer have 1 channel, 2 if 2 channel and 3 if 3 channel

I would like to create a calculate column (Changing column) which indicate that the customer changed to a smaller subsciprtion or not (it means change to a fewer channel). I would like to get a 0 value, if the customer didn't changed his earliest subscription to a smaller channel and 1 if  yes. I would like to get the following table and I need help how to calculate Changin column?

 

 

Thanks in advance

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution in this workbook.  Go to PowerPivot > Manage.  You can import this into PowerBI dekstop by simply going to File > Import > Excel file.

     

    Hope this helps.

     

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    You may refer to my solution in this workbook.  Go to PowerPivot > Manage.  You can import this into PowerBI dekstop by simply going to File > Import > Excel file.

     

    Hope this helps.

     

    • bog12345's avatar
      bog12345
      Frequent Visitor
      8 years ago

      Dear Ashish_Mathur,

       

      Thanks for your solution, it seems to be good. But I have more questions, how you make the Index column?

       

      Thanks in advance,

       

      Bog

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        I did that using the Query Editor.  I wrote an M code there is get those numbers.