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 sub...
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.

     

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.

    • bog12345's avatar
      bog12345
      Frequent Visitor
      8 years ago

      Dear Ashish_Mathur,

       

      Thank you very much, it works.

       

      I'm very grateful.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        You are most welcome.