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...😊

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

This calculated column formula works

Column = if(Data[New Value]="CAD",24*60*(CALCULATE(MIN(Data[Date and time]),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Date and time]>EARLIER(Data[Date and time])&&Data[New Value]="SÄ„MATOS RUOÅ IMAS"))-Data[Date and time]),BLANK())

Hope this helps.

 

Augustinas's avatar
Augustinas
Frequent Visitor
2 years ago

Thank You !