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])
8 Replies
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 PMAgent Name
invoker
lina
Shadow Demon
Alchemist
Bristleback
Sven
AlchemistValidator
9586487264
9586487389
9586487256
9586487264
9586487389
9586487839
9586487264Days repeated call
Answer Should look like this
1/1/19 10:39 AM
1/1/19 1:03 PM1/1/19 1:59 PM
Remarks
on Days repeated call Should get the Date on the Second CallAnonymous
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 All,
Need same assistance in converting this excel formula to Dax Power Bi.
=IF(ISNUMBER(SEARCH("REL CNF",[@[System status]])),"CNF",MID([@[System status]], 1, 4))
Thank you a lot!
