Forum Discussion
Converting Excel Formula to Power BI
Hi All, Need your outmost assistance on converting this excel formula to Dax Power Bi. Thank you in advance!!
Anonymous
maybe you can try to create a column
Column = minx(FILTER('Table','Table'[Validator]=EARLIER('Table'[Validator])&&'Table'[Date of Call]>EARLIER('Table'[Date of Call])),'Table'[Date of Call])
Hi negi007 ,
Thank you so much i can now see a little light on this thing hope you can help me.
Make this to be more Simpler.
Here's the table:
Date of Call
1/1/19 2:28 AM
1/1/19 8:51 AM
1/1/19 10:26 AM
1/1/19 10:39 AM
1/1/19 1:03 PM
1/1/19 1:53 PM
1/1/19 1:59 PM
Agent Name
invoker
lina
Shadow Demon
Alchemist
Bristleback
Sven
Alchemist
Validator
9586487264
9586487389
9586487256
9586487264
9586487389
9586487839
9586487264
Days repeated call
Answer Should look like this
1/1/19 10:39 AM
1/1/19 1:03 PM
1/1/19 1:59 PM
Remarks
on Days repeated call Should get the Date on the Second Call
ryan_mayu
Super User
Super UserAnonymous
maybe you can try to create a column
Column = minx(FILTER('Table','Table'[Validator]=EARLIER('Table'[Validator])&&'Table'[Date of Call]>EARLIER('Table'[Date of Call])),'Table'[Date of Call])Thank you so much Super Big Help...