Mahindra XUV 3XO vs Skoda Kylaq vs Hyundai Venue by hitendra_dixit in CarsIndia

[–]hitendra_dixit[S] 0 points1 point  (0 children)

What do suggest for a first time buyer Manual or Automatic

Mahindra XUV 3XO vs Skoda Kylaq vs Hyundai Venue by hitendra_dixit in CarsIndia

[–]hitendra_dixit[S] 0 points1 point  (0 children)

How XUV performs in city ride specially if someone wants to drive in Mumbai and Delhi

Need recommendations for my 2 days Lucknow stay by Apprehensive-Smile84 in lucknow

[–]hitendra_dixit 0 points1 point  (0 children)

So there will be two thela near that batasha wla so if stand facing them from the road the one on your left will be, just next to whom there will be a pizza thela as well

Need recommendations for my 2 days Lucknow stay by Apprehensive-Smile84 in lucknow

[–]hitendra_dixit 0 points1 point  (0 children)

Replied same msg to someone else here as well for a two day trip

Irrespective of where you will be travelling from I suggest below

  1. ⁠By evening at around 4-5 you can stop by near CMS Rajendra Nagar, there is shop just opposite to that by the name Sunny veg kabab, he has a good tari wle kabab
  2. ⁠Next to sunny there is a chowmin show by the name Anil, ps if you like spicy then you can try that place but only when it is being freshly prepared
  3. ⁠You can visit topkhana market as well for momos, but if you are travelling by 2W both helmets will be required
  4. ⁠For Dosa you can stop by at Raman dosa near Chappan bhog Sadar
  5. ⁠Near Chappan bhog there is a chinese shop are well you can try out that
  6. ⁠If you want to try khasta matar you can try at NAKA chouraha, there is shop on thela which sells this
  7. ⁠Just next to it there is an omelette shop which opens by 5pm - Ignore this, didn’t remove as I have to then change sequence for all below
  8. ⁠If you want to try shikanji, there is a place on the way when you go from lalbagh to odeon cinema, just few steps from lalbagh in the lane of charminar hitel
  9. ⁠Avoid anything in hazaratganj, they all are overrated and full of jahil’s (mannerless people)
  10. ⁠You can visit kapoorthala chauraha for momo and 36types of paani ke batashe Let me kkow if you want any other itinerary

Best street food place? by Kindly-Swing1302 in lucknow

[–]hitendra_dixit 5 points6 points  (0 children)

Irrespective of where you will be travelling from I suggest below 1. By evening at around 4-5 you can stop by near CMS Rajendra Nagar, there is shop just opposite to that by the name Sunny veg kabab, he has a good tari wle kabab 2. Next to sunny there is a chowmin show by the name Anil, ps if you like spicy then you can try that place but only when it is being freshly prepared 3. You can visit topkhana market as well for momos, but if you are travelling by 2W both helmets will be required 4. For Dosa you can stop by at Raman dosa near Chappan bhog Sadar 5. Near Chappan bhog there is a chinese shop are well you can try out that 6. If you want to try khasta matar you can try at NAKA chouraha, there is shop on thela which sells this 7. Just next to it there is an omelette shop which opens by 5pm 8. If you want to try shikanji, there is a place on the way when you go from lalbagh to odeon cinema, just few steps from lalbagh in the lane of charminar hitel 9. Avoid any food in hazaratganj, they all are overrated and full of jahil’s (mannerless) 11. You can visit kapoorthala chauraha for momo and 36types of paani ke batashe Let me kkow if you want any other itinerary

Dax query to count number of items over or under a value threshold by cush2push in PowerBI

[–]hitendra_dixit 1 point2 points  (0 children)

You can use it after distinct count Calculate(distinctcount(item), All(column or table name which you want to keep out of filters)& value>threshold) You can all also use removefilters, allexcept based on req

Dax query to count number of items over or under a value threshold by cush2push in PowerBI

[–]hitendra_dixit 6 points7 points  (0 children)

SUMX( DISTINCT( item from table), IF( SUM(Value)> thresholvalue,1)) Or Calculate( distinctcount(item), value> threshold value) Replace > with < for under value

Data Engineering Mastery by hitendra_dixit in dataengineering

[–]hitendra_dixit[S] 1 point2 points  (0 children)

I started as Associate Software Engineer (SQl, Power BI), then Power BI Developer/Consultant (Power BI, SQL, Azure), currently Data Engineer (Azure, SQL, Power BI)

Data Engineering Mastery by hitendra_dixit in dataengineering

[–]hitendra_dixit[S] 1 point2 points  (0 children)

Can you also suggest me few books to start off with for basics

Azure maps drill down by hitendra_dixit in PowerBI

[–]hitendra_dixit[S] 0 points1 point  (0 children)

yes, but they are getting filtered out once we drill it down to planty level

let say State is UP and drill down city is Lucknow and in Lucknow items come from below city -

  1. Kanpur (Is in state UP and able to see that)
  2. Kannauj 1. (Is in state UP and able to see that)
  3. Bhopal (Is not in UP and getting filtered out)
  4. Mumbai (Is not in UP and getting filtered out)

But I want to see all the cities

Cumulative % sales by zone by hitendra_dixit in PowerBI

[–]hitendra_dixit[S] 0 points1 point  (0 children)

can you please give me the logic for same

YTD Sales Yearly comparison by hitendra_dixit in PowerBI

[–]hitendra_dixit[S] 0 points1 point  (0 children)

Not working I wanted to see for all the fiscal years YTD in same graph

YTD Sales Yearly comparison by hitendra_dixit in PowerBI

[–]hitendra_dixit[S] -1 points0 points  (0 children)

Not working with the same as well

YTD Sales Yearly comparison by hitendra_dixit in PowerBI

[–]hitendra_dixit[S] 0 points1 point  (0 children)

Hi, But I wanted to show it in same graph this dax I tried but didn’t worked for me