Forum Discussion
Solved
Diference between 2 fltered values over commun id
Hello, I have a table in which I need to calcule (in a new column) diference between 2 date_time values, which has common id. There are 3 conditions over this formula: A) Calculate differenc...
Mario_6565 , Check if this file can help
https://www.dropbox.com/s/hilijhspfmoci35/Diff_between_status.pbix?dl=0
amitchandak
Super User
Super UserMario_6565 , Check if this file can help
https://www.dropbox.com/s/hilijhspfmoci35/Diff_between_status.pbix?dl=0
Hello amitchandak ,
Your code is brutal, thank you very much. For the end I have one question more.
Is it possible to keep just the first value in the column Diff?
Enclose photo
- amitchandak
if(Sheet1[ONOFF]="OFF" && isblank(Last Close]) ..... Rest is same
