gundugadu Posted January 13, 2021 Report Posted January 13, 2021 Is there any one who can provide some help/support on PowerBI project DAX stuff. Please pm vayyas if you can lend some time. Quote
Sarvapindi Posted January 13, 2021 Report Posted January 13, 2021 3 minutes ago, gundugadu said: Ltt Pm Quote
gundugadu Posted January 13, 2021 Author Report Posted January 13, 2021 @Sarvapindi iTeachSAP Buddy I have messaged you guys hope you see and help Quote
Democraticcompulsion Posted January 13, 2021 Report Posted January 13, 2021 Post here no. Solution teliste post chestaru kada.. I can give it a shot. Quote
gundugadu Posted January 13, 2021 Author Report Posted January 13, 2021 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 Quote
gundugadu Posted January 13, 2021 Author Report Posted January 13, 2021 1 hour ago, Democraticcompulsion said: Post here no. Solution teliste post chestaru kada.. I can give it a shot. posted the question baa Quote
Democraticcompulsion Posted January 13, 2021 Report Posted January 13, 2021 35 minutes ago, gundugadu said: posted the question baa Notwork enti.. null or some other random value aa Quote
gundugadu Posted January 13, 2021 Author Report Posted January 13, 2021 Some special category, where we by default populate False Quote
Democraticcompulsion Posted January 13, 2021 Report Posted January 13, 2021 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]) Quote
Democraticcompulsion Posted January 14, 2021 Report Posted January 14, 2021 Did you figure it out? Quote
gundugadu Posted January 14, 2021 Author Report Posted January 14, 2021 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. Quote
quickgun_murugun Posted January 14, 2021 Report Posted January 14, 2021 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? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.