Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yuta-msft,

 

Appreciate your sharing.

 

However, when I used measure for Index By Q No, I have multiple tables. I have trouble finding EARLIER function in my table and "Dense" is gray out. Refer photo screenshot:-

 

Once I solve the above Index By Q No, only can I used measure for DateDiff.

 

Let me know your thoughts

 

Thank You

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yuta-msft

 

Let  me know if you have a way to solve my queries 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi BDA2,

     

    You should create calculate column, not measure.

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-yuta-msft

      It works thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        hi v-yuta-msft

         

        Apparently I came to notice that the formula applies if my stages are distinct/not duplicated.

        How should I get the same output for multiple duplicated stages for the same quote ?