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)

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

        Hi,

        Look at the Partition step there.  That line has to be manually written.  It is because of this step that different index numbers are being assigned.