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.

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.