#mjoy - Twitter Hashtag

9 months ago

How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery

0

64

4

46

2K

Chandeep Chhabra

@chandeep2786

10 months ago

Messy Employee IDs? One Power Query line fixes it: "E-" & Text.PadStart(Text.From([Emp ID]), 5, "0") Transforms: 123 → E-00123 2 → E-00002 Professional formatting. One formula. Done. ✨ #MJoy

chandeep2786's tweet photo. Messy Employee IDs? One Power Query line fixes it:

"E-" & Text.PadStart(Text.From([Emp ID]), 5, "0")

Transforms:

123 → E-00123
2 → E-00002

Professional formatting. One formula. Done. ✨
#MJoy https://t.co/9mrZmaMoqg

1

79

7

43

3K

Chandeep Chhabra

@chandeep2786

12 months ago

How to make shorter queries in #PowerQuery #MJoy

1

58

5

51

2K

Chandeep Chhabra

@chandeep2786

about 1 year ago

Transform Multiple Columns at once in #PowerQuery #Mjoy

1

65

6

39

3K

Chandeep Chhabra

@chandeep2786

about 1 year ago

#PowerQuery trick battle with Geert Demulle. Lot of goodness in here #Mjoy

2

59

9

26

1K

Chandeep Chhabra

@chandeep2786

about 1 year ago

See how your queries are interconnected in #PowerQuery #Mjoy

1

31

1

10

1K

Chandeep Chhabra

@chandeep2786

about 1 year ago

The DRY Trick. Don't Repeat Yourself even in #PowerQuery #Mjoy

1

35

3

21

2K

Chandeep Chhabra

@chandeep2786

over 1 year ago

The Magic of { {Nested Lists}, {in Power Query} } #Mjoy #PowerQuery

1

95

12

61

4K

Chandeep Chhabra

@chandeep2786

about 2 years ago

Some #PowerQuery best practices while combining data from multiple Excel Files. #Mjoy

2

137

29

220

11K

Chandeep Chhabra

@chandeep2786

about 2 years ago

This is me competing with @exceloffthegrid (Mark Proctor) to score some points on awesome #PowerQuery tricks. #mjoy

2

36

6

23

3K

Chandeep Chhabra

@chandeep2786

about 2 years ago

The Second Query (Query1 because I rushed to post this on Twitter) with 2 steps. ➜ Source as Dates Column ➜ Custom2 with List.Accumulate to add multiple columns. #mjoy

chandeep2786's tweet photo. The Second Query (Query1 because I rushed to post this on Twitter) with 2 steps.
➜ Source as Dates Column
➜ Custom2 with List.Accumulate to add multiple columns.

#mjoy

2

1

0

2

525

Chandeep Chhabra

@chandeep2786

about 2 years ago

Here are some very interesting (and probably advanced) Grouping Tricks in @MSPowerQuery #Mjoy

4

68

13

39

4K

Chandeep Chhabra

@chandeep2786

about 2 years ago

Have you used Table Schema in #PowerQuery before, I think it is awesome. #Mjoy https://t.co/t07hO8IgFR

1

52

12

27

4K

Chandeep Chhabra

@chandeep2786

about 2 years ago

Fun trick to Remove the Promoted Headers Step in #PowerQuery #Mjoy https://t.co/t07hO8IgFR

5

49

8

19

3K

Chandeep Chhabra

@chandeep2786

about 2 years ago

Here is how you can do some weird things in #PowerQuery. #MJoy

1

69

3

24

4K

Mobilla @Mobilla0fficial

over 2 years ago

Experience pure musical joy and immerse yourself in a world that brings pure beat to your heart with Mobilla's MJOY 101 Wireless Headphone . . . . #mobilla #harpalkeliye #PlayYourWay #mjoy #mjoy101 #headphone #music #sound

Mobilla0fficial's tweet photo. Experience pure musical joy and immerse yourself in a world that brings pure beat to your heart with Mobilla's MJOY 101 Wireless Headphone
.
.
.
.
#mobilla #harpalkeliye #PlayYourWay #mjoy #mjoy101 #headphone #music #sound https://t.co/eyEPO3wpPL

0

59

Mobilla @Mobilla0fficial

about 3 years ago

Looking for an immersive playback solution? Look no further than Mobilla’s MJoy 101, TWS headset! It features 40mm drivers and Bluetooth 5.0 for smooth connectivity for a mesmerizing music experience! . . #mobilla #harpalkeliye #PlayYourWay #pyw #mjoy #mjoy101 #TWS #headphones #headset #music #sound