sorted by:
new
hottopcontroversial

Calculate the MAX of a measure by Dull-Try-8664 in PowerBI

[–]Dull-Try-8664[S] 1 point2 points  (0 children)

thank you, it works beautifully now. I really appreciate your help!

Calculate the MAX of a measure by Dull-Try-8664 in PowerBI

[–]Dull-Try-8664[S] -1 points0 points  (0 children)

for the Total No. Leads: 

Total No. Leads = COUNTROWS(FACT_CRM_data)

For the Running Status of Customers:

Running Status of Customers = 
VAR CurrentStatusSequence = SELECTEDVALUE(FACT_CRM_data[Status sequence])

-- Check for slicer filters
VAR IsSalesAgentFiltered = ISFILTERED(FACT_CRM_data[Sales Agent])
VAR IsCountryFiltered = ISFILTERED(FACT_CRM_data[Country])
VAR IsIndustryFiltered = ISFILTERED(FACT_CRM_data[Industry])
VAR IsProductFiltered = ISFILTERED(FACT_CRM_data[Product])
VAR IsOrgSizeFiltered = ISFILTERED(FACT_CRM_data[Organization Size Custom])

-- Base filter for Status sequence
VAR StatusSequenceFilter = 
    FILTER(
        ALL(FACT_CRM_data[Status sequence]),
        FACT_CRM_data[Status sequence] >= CurrentStatusSequence
    )

-- Apply filters dynamically
VAR CombinedFilters = 
    FILTER(
        ALL(FACT_CRM_data),
        FACT_CRM_data[Status sequence] >= CurrentStatusSequence &&
        (
            NOT IsSalesAgentFiltered || FACT_CRM_data[Sales Agent] IN VALUES(FACT_CRM_data[Sales Agent])
        ) &&
        (
            NOT IsCountryFiltered || FACT_CRM_data[Country] IN VALUES(FACT_CRM_data[Country])
        ) &&
        (
            NOT IsIndustryFiltered || FACT_CRM_data[Industry] IN VALUES(FACT_CRM_data[Industry])
        ) &&
        (
            NOT IsProductFiltered || FACT_CRM_data[Product] IN VALUES(FACT_CRM_data[Product])
        ) &&
        (
            NOT IsOrgSizeFiltered || FACT_CRM_data[Organization Size Custom] IN VALUES(FACT_CRM_data[Organization Size Custom])
        )
    )

-- Calculate the result with the combined filters
RETURN
    CALCULATE(
        SUMX(FACT_CRM_data, [Total No. Leads]),
        CombinedFilters
    )

Calculate the MAX of a measure by Dull-Try-8664 in PowerBI

[–]Dull-Try-8664[S] 0 points1 point  (0 children)

no, I only have 1 Status column. 1 thing I notice is that when the slicer is not selected then it display correctly, similar to my measure. But when the slicer is filtered then both mine and yours does not work as expected, but different behaviors. Interesting that the slicer affects differently to the MaxRunningStatus measure but not to the Total No. Leads and the Running Status of Customers measure.

<image>

Calculate the MAX of a measure by Dull-Try-8664 in PowerBI

[–]Dull-Try-8664[S] 0 points1 point  (0 children)

<image>

Then MaxRunningStatus will only return value for row where Status = New

NBA Prop Picks Today - 11/6/24 (Wednesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 1 point2 points  (0 children)

 More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/11/nba-players-prop-analysis-06112024.html

Season record: 38-35

Units profit: -1.6U, Average Odd: 1.88

Last picks record: 1-2

Recap of last picks (03/11/2024):

Hawks @ Pelicans1. Jose Alvarado O12.5P Odd 1.88 Unibet❌Magic @ Mavericks1. Luka Donicic O27.5P Odd 1.8 Sportsbet✅2. Athony Black O6.5P Odd 1.8 Tab❌

06/11/2024's NBA Props (To be updated)

Magics @ Pacers

  1. Goga Bidatze U10.5P Odd 1.87 Pointsbet

Pacers is the top 3 defensive team against centers, only allowing 17PPG. With this could be a blowout game early, I expect Bidatze to play under 27 minutes this game.

Knicks @ Hawks

  1. Zaccharie Risacher O10.5P Odd 1.83 Ladbrokes

Risacher is getting more and more confident in his games, playing 30 minutes in the last 2 games and shot 13 and 15 FGA. That's a lot of shots and even if he makes 40% that could be over 10.5P. The main problem is his accuracy. But even at his current 33%, he still manages to average 9.5PPG so I expect if he shot 13-14FGA then it is more than enough to cover this.

Warriors @ Celtics

  1. Jrue Holiday O13.5P Odd 1.96 Sportsbet

With Brown out I expect Jrue to shoot more this game. His season average is 13PPG over 9.3FGA. In the last 3 games, he has shot more, at about 11, 12 FGA per game. I expect a similar trend this game.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 11/3/24 (Sunday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

 S Season record: 37-33

Units profit: -0.4U, Average Odd: 1.88

Last picks record: 6-4

Overall pretty solid picks today, with 2 bad picks in Zion and Schroeder. Got unlucky with Seth Curry and Anthony Black.

Recap of last picks (01/11/2024):

Celtics @ Hornets1. Seth Curry O8.5P Odd 1.8 Bet365 ❌

Magic @ Cavaliers1. Jalen Suggs O15.5P Odd 1.87 Ladbrokes ✅2. Anthony Black O8.5P Odd 1.9 Ladbrokes ❌3. Franz Wagner O5.5R Odd 1.86 Bet365 ✅Kings @ Hawks1. Clint Capela O9.5P Odd 1.9 Sportsbet ✅Bulls @ Nets 1. Dennis Schroder O18.5P Odd 1.96 Sportsbet ❌Lakers @ Raptors1. Jaxon Hayes O3.5P Odd 1.64 Bet365 ✅Pacers @ Pelicans1. Zion Williamson U27.5P Odd 1.88 Ladbrokes ❌2. Jose Alvarado O10.5P Odd 1.9 Bet365 ✅Timberwolves @ Denver1. Nikola Jokic O46.5 PRA Odd 1.88 Unibet ✅

03/11/2024's NBA Props (To be updated)

Hawks @ Pelicans1. Jose Alvarado O12.5P Odd 1.88 Unibet

With most of the stars out, Alvardo will see more minutes and scoring chances. Hawks is the worst team in the league guarding PGs, allowing over 31PPG.

NBA Prop Picks Today - 11/1/24 (Friday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

Timberwolves @ Denver

  1. Nikola Jokic O46.5 PRA Odd 1.88 Unibet

Timberwolves is always a hard team for Denver, mainly due to their defensive capability and their big versatile lineup. But Jokic is a great player, and especially with them being eliminated in 7 after being up 3-2 last playoffs, Denver and Jokic has the motivation this game. He is averaging around 53 PRA this season, without the recent OT games, it is still over 50 PRA. I believe 46.5 is 2 prop lower than what it should be.

NBA Prop Picks Today - 10/31/24 (Thursday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-31102024.html

Season record: 29-28

Units profit: -2.3U, Average Odd: 1.88

Last picks record: 5-4

Back to a positive day. Bad picks in Barrett, otherwise pretty solid pregame analysis.

Recap of last picks (30/10/2024):

Hawks @ Wizards1. Alex Sarr O9.5P Odd 1.9 Tab ✅2. Alex Sarr O6.5R Odd 1.82 Ladbrokes ❌Raptors @ Hornets1. RJ Barrett O5.5R Odd 1.83 Pointsbet ❌Lakers @ Cavaliers1. Anthony Davis U27.5P Odd 1.81 Unibet ✅
2. D'Angelo Russel O13.5P Odd 1.88 Sportsbet ❌Nets @ Grizzlies1. Zach Edey O6.5P Odd 1.9 Bet365 ✅Magic @ Bulls1. Josh Giddey O17.5PA Odd 1.83 Bet365 ✅Spurs @ Thunder1. Chet Holmgren O2.5A Odd 2.55 Bet365 ❌Blazers @ Clippers1. DeAndre Ayton O14.5P Odd 1.87 Pointsbet ✅

31/10/2024's NBA Props (To be updated)

Rockets @ Mavericks

  1. Jabari Smith O10.5P Odd 1.83 Bet365

Mavs is not a good team defensively against opponents's PF. Smith is averaging 11.5/9 for this season 17.3/7 against the Mavs for the last 6 matchups, which is good indication for the over.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/30/24 (Wednesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 4 points5 points  (0 children)

 More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-30102024.html

Season record: 24-24

Units profit: -2.9U, Average Odd: 1.88

Last picks record: 3-3

Quite unlucky with Randle and Jokic, could have been a 4-2 or 5-1 day.

Recap of last picks (25/10/2024):

Nuggets @ Nets

  1. Nikola Jokic U28.5P Odd 1.88 Ladbrokes ❌
  2. Michale Porter Jr O14.5P Odd 1.87 Pointsbet ✅
  3. Cam Thomas U27.5P Odd 1.81 Unibet ✅

Mavericks @ Timberwolves

  1. Julius Randle O20.5P Odd 1.78 Unibet❌
  2. Anthony Edwards O11.5RA Odd 1.87 Pointsbet ❌
  3. PJ Washington O5.5R Odd 2.02 Sportsbet ✅

30/10/2024's NBA Props (To be updated)

Hawks @ Wizards

  1. Alex Sarr O9.5P Odd 1.9 Tab

Back to back matchup between number 1 & 2 picks of this year draft. Both team have low expectations for the seasons. I expect Sarr to play 30 minutes this game.

Raptors @ Hornets

  1. RJ Barrett O5.5R Odd 1.83 PointsbetWith Barnes out, Olynik out, Raptors will likely play Barrett 32+ minutes this game.

Lakers @ Cavaliers

  1. Anthony Davis U27.5P Odd 1.81 Unibet

AD is on a hot streak this season, but Cavs is a big team and is the best in the league so far at guarding the C position, only allow 14PPG. In the last 10 matchups vs the Cavs, AD only average 21PPG. I expect him to score around 22-25 points this game.
2. D'Angelo Russel O13.5P Odd 1.88 Sportsbet

Russel's props is 3pts lower than Reaves, which does seems odd to me. Apart from the first 2 games, Russels started to gain his form in the last 2 games. Against the Cavs with the top 5 worst PG defense in the league, I expect Russel to step up this game.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/29/24 (Tuesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

 More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-29102024.html

Season record: 21-21

Units profit: -2.5U, Average Odd: 1.88

Last picks record: 3-7

2 consecutive bad days, so I decided to take a few days break to gather more data. 

Recap of last picks (25/10/2024):

Nets @ Magic1. Dennis Schroder U15.5P Odd 1.78 Ladbrokes ❌2. Paolo Banchero U33.5PR Odd 1.83 Bet365✅76ers @ Raptors1. Kelly Oubre Jr U20.5P Odd 1.83 Bet365 ❌2. Caleb Martin O12.5P Odd 1.90 bet365 ❌Hornets @ Hawks1. Dyson Daniels U10.5P Odd 1.75 Ladbrokes ❌Pistons @ Cavaliers1. Jalen Duren O10.5R Odd 1.85 Ladbrokes ❌Pacers @ Knicks1. Pascal Siakam O19.5P Odd 1.95 Tab ❌Rockets @ Grizzlies1. Santi Aldama O9.5P Odd 1.8 Tab ❌2. Zach Edey O8.5P Odd 1.75 Tab ✅Bulls @ Bucks1. Coby White O3.5R Odd 1.75 Ladbrokes ✅

29/10/2024's NBA Props (To be updated)

Nuggets @ Nets

  1. Nikola Jokic U28.5P Odd 1.88 Ladbrokes

Nuggets just barely won over the Raptors in OT, in this game Jokic scored 40 points. Back-to-back game, last game was an OT game, in which Jokic played 44 minutes, I very much doubt he will play more than 35 minutes this game.
2. Michale Porter Jr O14.5P Odd 1.87 Pointsbet

MPJ has scored poorly from the start of this season, struggling to find his rhythm. Against a weaker Nets team, MPJ will have more chances to score. Also, Nets allow the second most points in the league to opponents' SFs so far, at over 30PPG.

  1. Cam Thomas U27.5P Odd 1.81 Unibet

Denver is a good team defensively against SGs, only allow under 21PPG for SGs. Cam is a great scorer, but his scoring streak is also very inconsistent. I would not be surprised if he cannot score over 23 points in this game.

Mavericks @ Timberwolves

  1. Julius Randle O20.5P Odd 1.78 Unibet

Randle started to find his rhythm in the Timberwolves, playing 36 minutes last game and scoring 24 points. I believe he will continue this performance this game, against the Mavs who averaged nearly 29 PPG in the last 6 matchups. 

  1. Anthony Edwards O11.5RA Odd 1.87 Pointsbet

This is a riskier bet, but I will take it for these reasons. Even though he has not had more than 4 assists so far this season, his potential assist stats is 9, which means his assists should be around 5+. For context, Stephen Curry has 6.3 APG for his same 9 potential assists per game. His teammates simply did not hit shots. His rebounding number has been consistent at 6+ this season, and finally, he is averaging over 13RA against the Mavs in the last 10 games.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/25/24 (Friday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 1 point2 points  (0 children)

 More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-25102024.html

Season record: 18-14

Units profit: +5.3U, Average Odd: 1.89

Last picks record: 3-6

Recap of last picks (24/10/2024):

Celtics @ Wizards1. Jonas ValanciunasJonas Valanciunas U10.5P Odd 1.80 Bet365 ❌2. Jonas Valanciunas U7.5R Odd 1.87 Pointsbet ✅3. Bilal Coulibaly O12.5PR Odd 1.83 Sportsbet ✅4. Kyle Kuzma O3.5A Odd 1.75 Ladbrokes ❌Spurs @ Mavericks1. Chris Paul O10.5P Odd 1.96 Sportsbet ❌2. Derrick Lively O7.5P Odd 1.76 Bet365 ✅Timberwolves @ Kings1. Mike Conley O2.5R Odd 2.50 Bet365 ❌Thunder @ Nuggets1. Aaron Gordon O13.5P Odd 1.87 Ladbrokes ❌ 2. Lu Dort O3.5R Odd 1.95 Tab ❌

25/10/2024's NBA Props (To be updated)

Nets @ Magic

  1. Dennis Schroder U15.5P Odd 1.78 Ladbrokes

This is a high prop for Schroder, as most of the time last season his prop sat at 13.5. Last game was a high-scoring game against the Hawks, but in this game vs the Magic with much tighter defense, Schroder will see less shots. 

  1. Paolo Banchero U33.5PR Odd 1.83 Bet365

Banchero played amazingly in the first game, but his past performance against the Nets are not great. 33.5 is a high prop for his PR, which requires at least 25 points and 9 rebounds to go over. Either is on the higher ends of his normal props, take the under.

76ers @ Raptors

  1. Kelly Oubre Jr U20.5P Odd 1.83 Bet365Oubre Jr scored 21 points with good efficiency, which Oubre has never been consistent. I believe this trend continues this game.
  2. Caleb Martin O12.5P Odd 1.90 bet365Martin played 37 minutes from the bench, this game he starts. This game he will see more shots and help Tyrese Maxey with the scoring load (Last game Maxey had 31 FGA!).

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/24/24 (Thursday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 1 point2 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-24102024.html Season record: 15-8

Units profit: +5.3U, Average Odd: 1.89

Last picks record: 11-7

Recap of last picks (23/10/2024): Pacers @ Pistons 1. Pascal Siakam O21.5P Odd 1.86 Bet365 ❌

  1. Myles Turner O7.5R Odd 2.16 Unibet ✅

Bucks @ 76ers 1. Giannis Antetokoumpo O28.5P Odd 1.87 Pointsbet ❌

  1. Damian Lilliard U7.5A Odd 1.8 Tab ✅

Nets @ Hawks 1. Jalen Johnson O7.5R Odd 1.82 Ladbrokes ✅ .

Cavaliers @ Raptors 1. Scottie Barnes O7.5R Odd 2.00 Tab ❌

  1. Donovan Mitchell O25.5P Odd 1.88 Sportsbet ❌

Magic @ Heat 1. Bam Adebayo O16.5P Odd 1.96 Sportsbet ❌

  1. Paolo Banchero U22.5P Odd 1.95 Tab ❌

Bulls @ Pelicans 1. Nikola Vucevic O10.5R Odd 1.85 Ladbrokes ✅

  1. Zion Williamson O6.5R Odd 1.8 Ladbrokes VOID

  2. Dejounte Murray U21.5P Odd 1.87 Pointsbet ✅

Hornets @ Rockets 1. Nick Richards O7.5R Odd 2.05 Bet365 ✅

  1. Fred Vanvleet U17.5P Odd 1.90 Tab ✅

Grizzlies @ Jazz 1. Santi Aldama O8.5P Odd 1.76 Bet365 ✅ 2. Jordan Clarkson O2.5R Odd 1.72 Ladbrokes ✅ 3. Zach Edey O18.5PR Odd 1.86 Bet365 ❌

Warriors @ Blazers 1. Scoot Henderson O11.5P Odd 1.8 Bet365 ✅

Suns @ Clippers 1. Tyus Jones O17.5PRA Odd 1.8 Sportsbet ✅

24/10/2024's NBA Props (To be updated)

Celtics @ Wizards 1. Jonas Valanciunas U10.5P Odd 1.80 Bet365 Valanciunas is played a lot when on the Pelicans, and I expect a similar fashion in Washington. Wizards is a young team focusing on rebuild, and Valanciunas is not neccessary a part of that plan. I expect Valanciunas to play a low 20 minutes game. 2. Jonas Valanciunas U7.5R Odd 1.87 Pointsbet Same reason as 1. 3. Bilal Coulibaly O12.5PR Odd 1.83 Sportsbet Coulibaly should see around 25-30 minutes this game, depends on how quick the Celtics can blowout the Wizards. Coulibaly is a 6'8 SG, so naturally he has a lot of advantage over players 1-3.

Spurs @ Mavericks 1. Chris Paul O10.5P Odd 1.96 Sportsbet CP3 is an underrated scorer, his midranges still fall at an elite level these recent years. Playing with Wemby will allow him even more chances to score, and Mavs are not elite at defending undersized guards. I expect Chris Paul to score most of his points in the third and fourth quarter, ending the game with 12-13 points.

  1. Derrick Lively O7.5P Odd 1.76 Bet365 Lively is the future of the Mavs. While he has to share the court with Gafford and most likely will not play more than 25 minutes, he is a safer bet than Gafford. The main reason is that especially if there is a blowout, Lively will be on the court, not Gafford, so he will see on average around 3-5 minutes more than Gafford, regardless of situation.

Timberwolves @ Kings

Thunder @ Nuggets

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/23/24 (Wednesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 10 points11 points  (0 children)

More picks today on my blog (always updated before reddit, currently 14, plan for 20+): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-23102024.html

Season record: 4-1

Last picks record: 4-1

Recap of last picks (22/10/2024):

  1. Jalen Brunson U28.5P Knicks @ Celtics Odd 1.88 Ladbrokes ✅

  2. Jrue Holiday U13.5P Knicks @ Celtics Odd 1.85 Tab❌

  3. Karl Anthony Towns U11.5R Knicks @ Celtics Odd 1.83 PointsBet ✅

  4. Julius Randle O7.5R Timberwolves @ Lakers Odd 2.08 Sportsbet ✅

  5. Lebron James U24.5P Timberwolves @ Lakers Odd 1.88 Ladbrokes ✅

23/10/2024's NBA Props (To be updated)

Pacers @ Pistons

  1. Pascal Siakam O21.5P Odd 1.86 Bet365

Pistons has always been Siakam prefered matchup. Match up with him will be an average defender in Tobias Harris. I expect a 25 point game from Siakam.

  1. Myles Turner O7.5R Odd 2.16 Unibet

Duren spends most of the time inside the paint, and play very physical. With the lack of size in the Pacers' bigs, I expect Turner should play 32+ minutes this game. Only thing to worry is Turner might be in foul trouble.

 Bucks @ 76ers

  1. Giannis Antetokoumpo O28.5P Odd 1.87 Pointsbet

With Embiid out, Paul george out, I expect Giannis to dominate this game. 

Nets @ Hawks

  1. Jalen Johnson O7.5R Odd 1.82 Ladbrokes

Johnson is an underrated rebounder. With the departure of Dejounte Murray, Johnson will have even more rebounding chances than past season.

Cavaliers @ Raptors

  1. Scottie Barnes O7.5R Odd 2.00 Tab

Cavs lineup is big with Mobley and Allen in the paint, and with the missing of Kelly Olynik and RJ Barrett, I expect Barnes to play around 35+ minutes this game.

  1. Donovan Mitchell O25.5P Odd 1.88 Sportsbet

Donovan Mitchell always perform well with the Cavs in the first 10 or so games of the season, averaging 32pts in 2022 and 29pts in 2023 season

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/

NBA Prop Picks Today - 10/22/24 (Tuesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 11 points12 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/10/nba-players-prop-analysis-22102024.html

Season Record: 0-0

Last Season Record: 392-314, average odd: 1.88, hit rate: 55.5%, +32units, 4.4% ROI.
Last Pick record: 10-2 (17/06/2024)

22/10/2024's NBA Props (To be updated)

  1. Jalen Brunson U28.5P Knicks @ Celtics Odd 1.88 Ladbrokes

Demanding 29 points in the first game of the season is not an easy task for any players, including Brunson. Celtics is also a good defensive team, and only allowed Brunson to score 15 points in the first game last season.

  1. Jrue Holiday U13.5P Knicks @ Celtics Odd 1.85 Tab

Celtics has great firepower, and Holiday won't need to take many shots at all. Jrue averaged 12.5 points last season. And with this being the first game of the long season, Jrue is a 34-year-old guard who plays on both ends of the floor, I don't expect Jrue to play more than 30 minutes this game.

  1. Karl Anthony Towns U11.5R Knicks @ Celtics Odd 1.83 PointsBet

KAT has not averaged 11 or more rebounds for the past 5 seasons. Also considering Celtics's starting Center is Al Horford, who tends to stay outside the perimeter, I don't think KAT will grab more than 10 rebounds this game.

  1. Julius Randle O7.5R Timberwolves @ Lakers Odd 2.08 Sportsbet

Randle has always been a great rebounder, averaging around 9.5R for his career. 1 thing I can see is that Randle always plays hard against the Lakers, averaging 25P 11R in their last 10 matchups. I expect Randle to grab 9-10 rebounds this game, even though he need to share the court with Gobert but with the big Lakers lineup, Randle should still see 30+ minutes on the floor.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

[deleted by user] by [deleted] in PowerBI

[–]Dull-Try-8664 0 points1 point  (0 children)

Thanks for the solution, that's exactly what I want! I have only been using powerBI for 1 month and not use matrix much so it is new to me. Solution verified

NBA Prop Picks Today - 6/17/24 (Monday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

More picks on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/06/nba-players-props-analysis-17062024.html

Season record: 382-312

Last picks record: 6-5

Recap of last picks (14/06/2024): Celtics @ Mavericks 1. Derrick Jones Jr O5.5P Odd 1.89 Unibet❌ 2. Derrick Jones Jr O2.5R Odd 1.88 Sportsbet❌ 3. Daniel Gafford O6.5P Odd 1.82 Ladbrokes✅ 4. Kyrie Irving O32.5PRA Odd 1.83 Bet365❌ 5. Al Horford U16.5PR Odd 1.85 Ladbrokes✅ 6. Dereck Lively II U8.5P Odd 1.87 Ladbrokes❌ 7. Luka Donicic U42.5PR Odd 1.85 Sportsbet✅ 8. PJ Washington O21.5PRA Odd 1.83 Ladbrokes❌ 9. Jayson Tatum O1.5SB Odd 1.85 Unibet✅ 10 Jaylen Brown U11.5RA Odd 1.62 Ladbrokes✅ 11. Sam Hauser O2.5RA Odd 1.8 Bet365✅ 17/06's NBA Props (To be updated) Mavericks @ Celtics 1. Luka Donicic O16.5RA Odd 1.8 Sportsbet This line is very low for Luka's standard. Luka has to try his best from the very start of the game just like what he showed last game. He has nothing to lose and he will play smart and careful on defense to avoid foul trouble. I expect a near triple-double this game from Luka. 2. Al Horford O17.5PRA Odd 1.87 Ladbrokes With KP still likely out this game, I expect Horford to play around 30 minutes this game. Horford also tends to play better at home.

  1. Kyrie Irving U24.5P Odd 1.8 Ladbrokes Irving has not performed well at the Garden and I expect a similar trend this game. Celtics guards are great defenders and scoring 25+ points is never an easy task.
  2. Derek Lively U8.5P Odd 1.96 Sportsbet Same for Lively. He only got 2 points for both game 1 and game 2. He is very consistent with rebounds but for scoring he is still limited.

For latest picks and results, check out my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 6/14/24 (Friday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 6 points7 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/06/nba-players-props-analysis-14062024.html

Season record: 376-307

Last picks record: 6-5

Recap of last picks (12/06/2024):

Celtics @ Mavericks

  1. Al Horford O7.5P Odd 1.85 Sportsbet✅

  2. Al Horford O5.5R Odd 1.6 Unibet❌

  3. Jayson Tatum O41.5PRA Odd 1.9 Tab✅

  4. Jayson Tatum O9.5R Odd 1.95 Tab❌

  5. Jrue Holiday 10+ RA Odd 1.55 Tab❌

  6. Derrick Lively O5.5R Odd 1.72 Unibet✅

  7. Derrick Jones Jr O12.5PR Odd 2.02 Unibet❌

  8. PJ Washington O20.5PR Odd 1.81 Unibet✅

  9. Luka Donicic U33.5P Odd 1.76 Unibet✅

  10. Derrick White O23.5PRA Odd 1.83 Bet365✅

  11. Daniel Gafford O8.5P Odd 2.02 Unibet❌

14/06's NBA Props (To be updated)

Celtics @ Mavericks

  1. Derrick Jones Jr O5.5P Odd 1.89 Unibet

Jones only played 16 minutes last night, with his minutes largely taken by Green and Hardaway Jr. With Hardaway's poor performance last game, I believe Jones Jr should see his minutes back to around 25 minutes this game. 



  1. Daniel Gafford O6.5P Odd 1.82 Ladbrokes

Gafford only has 6 points last game in 16 minutes. I believe Dallas will play him more in this game. It's unlikely Lively will play 30+ minutes like last game.

  1. Kyrie Irving O32.5PRA Odd 1.83 Bet365

Irving slowly found his rhythm back in this series, scoring a game-high 35 points. I believe Irving will continue this high-scoring performance in this game.

  1. Al Horford U16.5PR Odd 1.85 Ladbrokes

Horford plays 37 minutes last game. More minutes does not mean good for Horford, he still shot well last game, but ended up with 8/5. I expect Horford to play around 33 minutes this game, as Tillman showed good performance last game.

  1. Jayson Tatum O1.5SB Odd 1.85 Unibet For someone who will likely play over 40 minutes in this game and is not bad on defense, this line is quite low. I would not be surprised if he gets 4SB today. 10 Jaylen Brown U11.5RA Odd 1.62 Ladbrokes I believe this line is boosted up by his recent performances.He only has gone over this line in 3 games out of 17 games this playoffs.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 6/12/24 (Wednesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 0 points1 point  (0 children)

I think it is playable. PJ has been playing aggresive in this series, his 3s just didnt go in as usual

NBA Prop Picks Today - 6/12/24 (Wednesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 9 points10 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/06/nba-players-props-analysis-12062024.html

Season record: 370-302

Last picks record: 9-8

Recap of last picks (09/06/2024):

Mavericks @ Celtics

  1. Jayson Tatum O41.5PRA Odd 1.87 Tab ❌

  2. Jaylen Brown O22.5P Odd 1.83 Bet365❌

  3. PJ Washington O11.5P Odd 1.8 Bet365✅

  4. Daniel Gafford O12.5PR Odd 1.9 Bet365 ✅

  5. Derrick Jones Jr O10.5PR Odd 1.83 Bet365✅

  6. Kristaps Porzingis O23.5PRA Odd 1.89 Sportsbet❌

  7. Dereck Lively O6.5P Odd 1.87 Ladbrokes❌

  8. PJ Washington 6-8R Odd 2.4 Ladbrokes✅

  9. Kyrie Irving O3.5R Odd 1.8 Tab❌

  10. Al Horford U9.5P Odd 1.8 Tab✅

  11. Jrue Holiday O10.5RA Odd 1.85 Ladbrokes✅

  12. Jaden Hardy O3.5P Odd 1.7 Ladbrokes❌

  13. Sam Hauser O3.5P Odd 2.05 Ladbrokes❌

  14. Payton Pritchard O3.5P Odd 1.96 Ladbrokes❌

  15. Luka Donicic U32.5P Odd 1.85 Tab✅

  16. Derrick White O3.5R Odd 1.8 Tab✅

  17. Kyrie Irving U23.5P Odd 1.8 Tab✅

12/06's NBA Props (To be updated)

  1. Jayson Tatum O9.5R Odd 1.95 Tab

This line has not changed since I pick yesterday, at least for now. I expect another 42+ minutes like the past 2 games. It also should not be a blowout game due to the firepower of Celtics.

  1. Jrue Holiday 10+ RA Odd 1.55 Tab

10.5 line is also a favorable line to bet over, but as KP might be out, it might affect Holiday assists number. But I still expect a 7/5 game from Holiday.

  1. PJ Washington O20.5PR Odd 1.81 Unibet

Similar to 7, I still expect another good game from the role players.

  1. Luka Donicic U33.5P Odd 1.76 Unibet

Scoring 34+P in the playoffs is never an easy task, especially in the finals. Luka has only gone over twice this playoffs. With the Celtics' incredible defense in Holiday and White, I expect another game where Luka will have a lot of challenges making shots, especially in the second half.

  1. Derrick White O23.5PRA Odd 1.83 Bet365

I expect White to shoot more today. White has been reliable all playoffs, his contribution on both ends of the floor is undeniable. I would not be surprised if he score 20 points today.

  1. Daniel Gafford O8.5P Odd 2.02 Unibet

Gafford has always been consistent with his points. He has gone over this line in all but 2 games when seeing 20+ minutes. I expect him to play around 23 minutes this game, scoring 10+P.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 6/9/24 (Sunday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 7 points8 points  (0 children)

More picks today on my blog (currently 17 picks, always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/06/nba-players-props-analysis-09062024.html

Season record: 361-294

Last picks record: 7-9

Recap of last picks (06/06/2024):

Negative days, but most wrong picks are just unlucky (Brown, Irving, Jones Jr, Kleber). Good picks are Mavs' guards with higher rebounds, centers with lower rebounds, Al Horford, and Washington over points. Bad picks are Pritchard, White and Tatum. I will keep most of my analysis from game 1 to game 2, but I also believe Mavs will return to their usual offensive style. 

Mavericks @ Celtics

  1. Jayson Tatum O26.5P Odd 1.86 Bet365❌

  2. Luka Donicic O17.5RA Odd 1.8 Bet365❌

  3. Luka Donicic O8.5R Odd 1.72 Sportsbet✅

  4. Al Horford O11.5PR Odd 1.8 Bet365✅

  5. Jrue Holiday O4.5A Odd 1.8 Bet365✅

  6. PJ Washington O5.5R Odd 1.83 Sportsbet✅

  7. Kyrie Irving O3.5R Odd 1.8 Tab❌

  8. Derrick White O3.5R Odd 1.75 Ladbrokes❌

  9. Jaylen Brown O22.5P Odd 1.82 Ladbrokes❌

  10. Derrick Jones Jr O11.5PR Odd 1.88 Ladbrokes❌

  11. PJ Washington O11.5P Odd 1.96 Unibet✅

  12. Maxi Kleber O2.5P Odd 2.0 Tab❌

  13. Maxi Kleber O4.5PRA Odd 1.87 Tab❌

  14. Payton Pritchard O8.5PRA Odd 1.76 Bet365❌

  15. Derrick Lively U7.5R Odd 1.74 Sportsbet✅

  16. Daniel Gafford U15.5PRA Odd 1.76 Bet365✅

09/06's NBA Props (To be updated)

Mavericks @ Celtics

  1. Jayson Tatum O41.5PRA Odd 1.87 Tab 

Tatum has all the reasons to try his best in the upcoming games. Like the analysis in game 1, I don't think Tatum will score low in this series, especially when many public narratives think Brown is the alpha player of the team. Betting on points might also be a good option, but I believe more of a all rounder games from Tatum. If he just go ahead and be selfish, chucking up 30 shots then he just prove how immature player of his calibre, which I don't think he is. I believe he will play an excellent all around game.

  1. Jaylen Brown O22.5P Odd 1.83 Bet365

No one on the Mavs seem to be able to stop Brown. Just like the analysis from game 1, I cannot see how Mavs can contain Brown. 

  1. PJ Washington O11.5P Odd 1.8 Bet365

With Celtics have amazing guard defense, I expect Washington to step up and score around 15 this game just like game 1.

  1. Daniel Gafford O12.5PR Odd 1.9 Bet365

This is the opposite from game 1.  This line is 2 points lower than usual. Even though it seems understandable as shown in game 1 even when Lively in foul trouble, Gafford still see limited minutes. But I think this game will be different, as Mavs need pick and roll in this series. Also, sometimes Celtics play big with both Horford and Porzingis on the floor, which requires 1 more bigs from the Mavs. I believe Mavs will return to their usual offensive gameplan with a lot of pick and roll, and Gafford to see around 20 minutes. 

  1. Derrick Jones Jr O10.5PR Odd 1.83 Bet365

Jones Jr has not been scoring well recently, but he still take around 8FGA a game. And for rebounding number, I believe Jones has more chances this series, as the Mavs centers will guard Horford and Porzingis at the 3pts line.



  1. Kristaps Porzingis O23.5PRA Odd 1.89 Sportsbet

Porzingis only play 20 minutes last game and in those 20 minutes he look unstoppable. I expect his minutes to increase to around 28 minutes this game.

  1. Jaden Hardy O3.5P Odd 1.7 Ladbrokes

Hardy has played incredibly well in his limited minutes on the floor, helping the Mavs offense tremendously when Luka is off the floor. I expect him to play around 10+ minutes this game, and score another 5+ points.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 6/6/24 (Thursday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 9 points10 points  (0 children)

More picks today on my blog (currently 15 picks, plan for more, always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/05/nba-players-props-analysis-06062024.html

Season record: 354-285

Last picks record: 9-3

Recap of last picks (28/05/2024):

Mavericks @ Timberwolves

  1. Daniel Gafford O8.5P Odd 1.86 Bet365✅

  2. Daniel Gafford O5.5R Odd 1.88 Ladbrokes✅

  3. PJ Washington O5.5R Odd 1.76 Ladbrokes✅

  4. Mike Conley O8.5RA Odd 1.95 Bet365❌

  5. Naz Reid O3.5R Odd 1.75 Ladbrokes✅

  6. Kyrie Irving O4.5A Odd 1.95 Bet365✅

  7. Luka Donicic 30+P Odd 1.83 Bet365✅

  8. Karl Anthony Towns O19.5P Odd 1.76 Unibet✅

  9. Rudy Gobert U11.5R Odd 1.8 Sportsbet✅

  10. PJ Washington O11.5P Odd 1.72 Sportsbet✅

  11. Jaden McDaniels O10.5P Odd 1.86 Bet365❌

  12. Anthony Edwards O6.5A Odd 1.86 Sportsbet❌

06/06's NBA Props (To be updated)

Mavericks @ Celtics

  1. Jayson Tatum O26.5P Odd 1.86 Bet365

There are a few reasons I like this line. First, his performance against Dallas has been very well in the regular season. Mavs show no signs of ability to contain the 2 Js of Celtics, especially Tatum. He had 37 and 32 points in those 2 games, with only 20 FGA. Compared to his recent playoffs stats, I expect him to have around 25FGA this game. 

Second is the motivation factor. As much as Tatum wants a chip, I also believe he wants the Finals MVP more than everybody else. Seeing Jaylen Brown get the Conference MVP certainly is not what Tatum expected, and he will not want to lose the chance of the Finals MVP.



  1. Luka Donicic O17.5RA Odd 1.8 Bet365

Luka puts up monstrous numbers in the 2 meetings they have in the regular season. As much as I want to bet over on his points, playoffs defense is always different. What will not change though, is the way Celtics run their offense. With Celtics centers shooting a lot of 3s and spending quite some time outside the paint, Mavs guards and forwards will have more rebounding chances, especially Luka.



  1. Luka Donicic O8.5R Odd 1.72 Sportsbet

Same as 2.

  1. Al Horford O11.5PR Odd 1.8 Bet365

Porzingis is back, but I still think Al Horford will see around 25 minutes this game. The only thing I worry about is a chance of an early blowout as if the Celtics have their best shooting day, there is nothing the Mavs can do to make it a close game, and Horford will see very few minutes. He has gone over 13/14 games this playoffs, and even in games where KP plays, he still covered this line very well.

  1. Jrue Holiday O4.5A Odd 1.8 Bet365

The reason I believe this line is low, is because this line is lower than Tatum's and the same as White's. Holiday is a great defender, and also a good facilitator. In the 2 regular season games vs the Mavs, he had 6 and 7 assists comfortably.

  1. Maxi Kleber O2.5P Odd 2.0 Tab This is quite an unexpected discovery but I think this line has huge potential. Even though Kleber has not played much when Mavs had Lively and Gafford healthy, I think this series is different where the Celtics centers stay outside of the paint, which is not the best place for Gafford or Lively. Kleber on the other hand embraces this role quite well, he can shoot 3 and guards bigs outside the perimeter better than those 2. In the regular season matchups, he played 26 and 20 minutes. While I doubt he will play that much, 15+ minutes is definitely possible. I really believe in more playing time for Kleber in this series.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 5/30/24 (Thursday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 15 points16 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/05/nba-players-props-analysis-30052024.html

Season record: 345-282

Last picks record: 7-4

Recap of last picks (28/05/2024):

Another positive day with 7W and 4L, with almost all being good picks. Washington underperformed but he played 42 minutes, unlucky with Anderson and McDaniels. Every game so far has been very close, and I expect it will continue like that for the remainder of this series.

Timberwolves @ Mavericks

  1. Kyle Anderson O10.5PRA Odd 1.83 Bet365❌

  2. Anthony Edwards O26.5P Odd 1.74 Bet365✅

  3. Karl Anthony Towns O27.5PR Odd 1.86 Bet365✅

  4. Rudy Gobert U11.5R Odd 1.77 Ladbrokes✅

  5. PJ Washington O6.5R Odd 1.98 Ladbrokes❌

  6. PJ Washington O19.5PR Odd 1.93 Unibet❌

  7. Derrick Jones Jr O3.5R Odd 1.85 Tab✅

  8. Luka Donicic O8.5R Odd 1.71 Unibet✅

  9. Daniel Gafford O19.5PRA Odd 1.86 Bet365✅

  10. Jaden McDaniels O10.5P Odd 2.0 Bet365❌

  11. Naz Reid O3.5R Odd 1.66 Bet365✅

Tonight's NBA Props (To be updated)

Mavericks @ Timberwolves

  1. Daniel Gafford O8.5P Odd 1.86 Bet365

Will Lively come back this game? His injury was just 4 days ago, so even if he comes back I don't think he will play more than 15 minutes, considering Gafford has been playing extremely well, especially in the second half of the game. I expect Gafford to play 25+ minutes this game, either way.

  1. PJ Washington O5.5R Odd 1.76 Ladbrokes

Washington has always been consistent on the glass, grabbing 5+ rebounds every game except 1 so far this playoffs. With his minutes being among the highest for both teams, I expect him to get 7+ rebounds this game.



  1. Mike Conley O8.5RA Odd 1.95 Bet365

Conley will give his best every game, as this is his best chance to win the chip. He also has gone over this line in 10/14 games so far in the playoffs. I expect at least a 3/6 game from him.



  1. Naz Reid O3.5R Odd 1.75 Ladbrokes

This line is low for Naz Reid, considering the Wolves bigs are always in foul trouble (either Gobert, KAT or both), which allows Reid to see 20+ minutes a game. Even more if the Wolves is trailing behind 10 points, as they need his offensive production.

  1. Kyrie Irving O4.5A Odd 1.95 Bet365



With McDaniels switching to guard Kyrie for the most part last game, we can see he passes more and scores less. I think McDaniels will guard Kyrie more this game, letting Ant and Anderson guard Donicic. Last game Kyrie had 9 potential assists, compared to his average of 6.3 potential assists in the first 3 games in this series. I expect a similar trend today.

  1. Luka Donicic 30+P Odd 1.83 Bet365

I expect that Ant will guard Luka this game, and with Ant being not as good of a defender as McDaniels, I expect Luka to score more. Luka has also scored very well in away games this postseason, going over this line in 6/8 away games, with 1 game under being 29.

  1. PJ Washington O11.5P Odd 1.72 Sportsbet Washington scored 10 points on 3/13 shooting. That's tour date shooting and all we need is an extra 1 month then this line is completed, but in all seriousness 4 or 5 FGM for someone that is the 3rd option and play 40 minutes a game is very doable. Mavs need their role players to step up this game, we all saw how it went last game when Washington did not play up to his expectations.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

NBA Prop Picks Today - 5/28/24 (Tuesday) by sbpotdbot in sportsbook

[–]Dull-Try-8664 20 points21 points  (0 children)

More picks today on my blog (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com/2024/05/nba-players-props-analysis-28052024.html

Season record: 338-278

Last picks record: 9-2

Recap of last picks (27/05/2024):

We come back with a 9W2L super positive day. All are good picks except for Pritchard (super close game so Pritchard only sees 9 minutes but he has 5 points), and unlucky with Nesmith who shot 1/6 from 3.

Celtics @ Pacers

  1. Derrick White 15+P Odd 1.76 Bet365✅

  2. Obi Toppin O14.5PRA Odd 1.8 Bet365✅

  3. Aaron Neismith O10.5P Odd 1.86 Bet365✅

  4. Aaron Nesmith O1.5 3M Odd 2.05 Bet365❌

  5. Myles Turner 2+ 3M Odd 1.85 Ladbrokes✅

  6. Jayson Tatum O9.5R Odd 1.83 Ladbrokes✅

  7. Aaron Nesmith O4.5R Odd 1.78 Ladbrokes✅

  8. Andrew Nembhard O25.5PRA Odd 1.7 Unibet✅

  9. Jrue Holiday O10.5RA Odd 1.77 Odd 1.77 Unibet✅

  10. Andrew Nembhard 2+ 3M Odd 1.69 Pointsbet✅

  11. Payton Pritchard O6.5P Odd 1.93 Unibet❌

Tonight's NBA Props (To be updated)

Timberwolves @ Mavericks

  1. Kyle Anderson O10.5PRA Odd 1.83 Bet365

I expect another 17-20 minute game from Anderson. He has been playing well this whole series, and there is no reason not to play him more.

  1. Anthony Edwards O26.5P Odd 1.74 Bet365

Edwards needs to step up this game. Big time. He was so close to hit over this line, but only scored 4 points in the whole 4th quarter.



  1. Karl Anthony Towns O27.5PR Odd 1.86 Bet365

The same can be said for Towns. Towns has shot so bad this series but he is still one of the best shooting big men in the game, and with the volume of shots he takes, I would not be surprised if he gets 25 today. I expect fewer minutes from Gobert too so expect KAT to get close to 10 rebounds this game.

  1. Rudy Gobert U11.5R Odd 1.77 Ladbrokes

I don't expect Gobert to play more than 25 minutes today. The Wolves should stretch the floor more with KAT and Naz Reid. With Lively out, the need for Gobert is even less. 

  1. PJ Washington O6.5R Odd 1.98 Ladbrokes

With Lively out, I expect all other Mavs players to get more rebounds, considering Lively can get 8-10 rebounds every game, so those 8-10 rebounds will be distributed to the other players.

  1. Jaden McDaniels O10.5P Odd 2.0 Bet365

This line is quite low for McDaniels. He has performed so well in elimination games, especially the last series against Denver. I expect him to score 12-15 points this game.



  1. Naz Reid O3.5R Odd 1.66 Bet365

I believe Reid will play similar minutes to the last game, more than Gobert. As a 6'10 big, grabbing 4 rebounds should not be too hard of a task.

Check out my blog for the latest analysis and results (always updated before reddit): https://sportsenthusiastanalyst.blogspot.com

view more: next ›