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

Augustinas's avatar
Augustinas
Frequent Visitor
2 years ago
IDReceived date and timeNew ValueDate and time.CAD status min.
187432024-05-02 14:08PAKLAUSIMAS5-2-2024 3:12:14 PM 
187432024-05-02 14:08CAD5-2-2024 5:08:48 PM985
187432024-05-02 14:08SĄMATOS RUOŠIMAS5-3-2024 9:34:08 AM 
187432024-05-02 14:08PASIŪLYMO RUOŠIMAS5-3-2024 9:34:30 AM 
187432024-05-02 14:08CAD5-3-2024 11:11:37 AM129
187432024-05-02 14:08SĄMATOS RUOŠIMAS5-3-2024 1:21:30 PM 
187432024-05-02 14:08MARŽOS NUSTATYMAS5-7-2024 8:26:21 AM 
187432024-05-02 14:08PASIŪLYMO PATIKRINIM5-7-2024 10:04:43 AM 
187432024-05-02 14:08PASIŪLYMO RUOŠIMAS5-7-2024 5:27:10 PM 
187432024-05-02 14:08PASIŪLYMAS IŠSIŲSTAS5-7-2024 7:43:07 PM 

 

E.g. SĄMATOS RUOŠIMAS (5-3-2024 9:34:08 AM) minus CAD (5-2-2024 5:08:48 PM) is 985 minutes.

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 !