Need help on powerbi project DAX

[gundugadu]

Is there any one who can provide some help/support  on PowerBI project DAX stuff.

Please pm vayyas if you can lend some time. 
 

 

[gundugadu]

Ltt

[Sarvapindi]

Wat u need pm

[Sarvapindi]

3 minutes ago, gundugadu said:

Ltt

Pm

[iTeachSAP]

I can... Pm me 

[gundugadu]

@Sarvapindi iTeachSAP

Buddy I have messaged you guys

hope you see and help

[Democraticcompulsion]

Post here no. Solution teliste post chestaru kada..

I can give it a shot.

[gundugadu]

My requirement is to make use of EventCode and Type category finally retrieve Output 2, which is stripping out Type from EventCode  and check if number exists and return true  using DAX

lets assume table name as TBL

EventCode    Type                           Output1             Output 2(Return true if number exist in string else false)

ABC03938      ABC                          03938                          True

ABC49nmkas  ABC                         49nmkas                       True     

RE0943mmjh  RE0                          943mmjh                       True

RE0SAM4B      RE0                          SAM4B                          True

RE0SAMB      RE                            0SAMB                             False

ABC4DEFG      NotWork              ABC4DEFG                      False   

ABCDEFG        NotWork                ABCDEFG                     False

[gundugadu]

1 hour ago, Democraticcompulsion said:

Post here no. Solution teliste post chestaru kada..

I can give it a shot.

posted the question baa

[Democraticcompulsion]

35 minutes ago, gundugadu said:

posted the question baa

Notwork enti.. null or some other random value aa

[gundugadu]

Some special category, where we by default populate False

[Democraticcompulsion]

1 hour ago, gundugadu said:

My requirement is to make use of EventCode and Type category finally retrieve Output 2, which is stripping out Type from EventCode  and check if number exists and return true  using DAX

lets assume table name as TBL

EventCode    Type                           Output1             Output 2(Return true if number exist in string else false)

ABC03938      ABC                          03938                          True

ABC49nmkas  ABC                         49nmkas                       True     

RE0943mmjh  RE0                          943mmjh                       True

RE0SAM4B      RE0                          SAM4B                          True

RE0SAMB      RE                            0SAMB                             False

ABC4DEFG      NotWork              ABC4DEFG                      False   

ABCDEFG        NotWork                ABCDEFG                     False

Output1=Right([EventCode],len(EventCode]-len([Type]) Not sure if this logic works for you.. but what I thought makes sense.

Output2= CONTAINSSTRING([Output1], [Type])

[Democraticcompulsion]

Did you figure it out?

[gundugadu]

I have implemented the solution  by creating a new  calculated column which will provide output 2 using variables.

will post the solution once I logon.

 

[quickgun_murugun]

On 1/12/2021 at 10:34 PM, gundugadu said:

Is there any one who can provide some help/support  on PowerBI project DAX stuff.

Please pm vayyas if you can lend some time. 
 

 

PoweBI la DAX full tough untada or doable?