Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Date Difference between two days in same column

Hello, i have a table with dates and index. i want to find number of dates between 2 days for same index number. here is the example "Results" is the output which i want. last date(max date of an...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ashish_Mathur 

    this works perfectly. 

    but can you please tell me how to get new index column(Index1) based on other Index?

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi ,

       

      You can add the index column in query edit. 

      Add column>index column>from 1

       

      Dina.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

      Good to know that.  Click on Home > Edit Queries and see the steps there.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ashish_Mathur 

        thank you. but this gives a index for all raws. 
        but here you got an index1 with respect to original index (separate index1 for index number 1 and separete index for index number 2)