Converting Excel Formula to Power BI

[Allan-Mautante]

Hi All,

Need your outmost assistance on converting this excel formula to Dax  Power Bi. 

Thank you in advance!!

[Msaba]

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!

[ryan_mayu]

@Msaba 

you can open a new post and pls provide the sample data and expected output.

[Msaba]

done. Thanks

Convert Excel 'search' function to DAX PowerBi - Microsoft Power BI Community

[Allan-Mautante]

Does anyone wants to shed some lights :'(

[negi007]

@Allan-Mautante 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.

[Allan-Mautante]

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 · Accepted solution]

@Allan-Mautante 

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])

[Allan-Mautante]

Thank you so much Super  Big Help...