Forum Discussion
Converting Excel Formula to Power BI
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])
Anonymous Hi Allan, could you please share value for all columns. In your excel sheet, there is no value in the validator column. To write any dax for this, I will have to have data in powerbi then only I can write/suggest a dax solution. If possible share data in text format so that we can copy and paste it into powerbi and then can do the testing.
looking forward to your response.
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
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])Thank you so much Super Big Help...