Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Days Difference between two dates in same column with duplicate dates in Power BI

I have a column with duplicate dates. I need to calculate date difference based on another column. For example, I have Stage column with 1,2,3... repeated values . What will be function I can use to...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    maybe you can try this

    measure=calculate(max(lastdate),allexcept(table,bomno))-calculate(min(lastdate),allexcept(table,bomno))

  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks a lot. It worked for me...😊

Anonymous's avatar
Anonymous
Not applicable
5 years ago

My sample data

 

So, I need days difference between first date and last date (in lastdate Column) based on bomno column. 

Thanks in advance..

 

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

maybe you can try this

measure=calculate(max(lastdate),allexcept(table,bomno))-calculate(min(lastdate),allexcept(table,bomno))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks a lot. It worked for me...😊

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      5 years ago

      you are welcome

  • YRK's avatar
    YRK
    New Member
    2 years ago



    Need DAX(Power BI) for no of days for Each SGNo from the Above Table.

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      what's the expected output? it's better to create a new postand provide the detailed info.