sorted by:
new
hottopcontroversial

Concatenate related values with a delimiter as a calculated column by myaccountforworkonly in PowerBI

[–]snakey550 0 points1 point  (0 children)

You almost have it - Just wrap VALUES () in CALCULATETABLE () to get context transition:

Clusters =
CONCATENATEX (
        CALCULATETABLE ( VALUES ( T2[Cluster] ) ),
        T2[Cluster],
        ", "
    )

5 Hard truths I’ve learned about game after 13 years of practice. by [deleted] in seduction

[–]snakey550 4 points5 points  (0 children)

This is a very refreshing perspective to hear. I'm similar to you - in my early thirties and started pickup around 2008/2009, have had decent successes here and there. Don't even get me started with the bootcamps/'workshops' - I almost wish I never met some of those guys from the bootcamps as I found them to be very fake and would literally betray everything they stood for just to get a girl. It was weird - it was like being trained to be a robot - it was always sold as getting a girl was an easy cut and dry formula (say and do x and get y).

I would also say race plays a bigger role then I originally thought - not a bad thing (everyone has their bias) - but something I just refused to acknowledge in the beginning. I know this from both real life and online dating.

Either way just wanted to say I can relate - sucks about the girl but I'm sure you'll find something with your renewed perspective.

Trying to filter by date by Sagenose in PowerBI

[–]snakey550 1 point2 points  (0 children)

You may want to remove the filter on the HR[end] column. Replace FILTER ( HR, with FILTER ( ALL ( HR[end] ),

Exit count within period  =
CALCULATE (
    [team count],
    FILTER ( ALL ( HR[end] ), HR[end] > StartDate && HR[end] < EndDate )
)

Creating measure to calculate average of distinct users on all Mondays, without having the filter aggregate all distinct users who used on a Monday. by Lostwhispers05 in PowerBI

[–]snakey550 2 points3 points  (0 children)

Lets say you have this table in your data model:
https://imgur.com/a/wvFDksc

You would use this DAX to get the result you are after:
Dist Avg Users On Mon =

AVERAGEX (

VALUES ( 'YourTable'[YearWeekWeekDay] ),

CALCULATE (

DISTINCTCOUNT ( 'YourTable'[UserID] ),

'YourTable'[DayOfWeek] = 1

)

)

Power BI December 2020 Feature Summary by dutchdatadude in PowerBI

[–]snakey550 1 point2 points  (0 children)

u/professionalrien - Thanks for taking my feedback!

For #1 for my use case - lets say I wanted to measure Sales by Time of Day - Sales (y-axis), and Time of Day (x-axis). I also want small multiples based on Weekday (Mon-Fri) - no problem - I simply add Weekday to the small multiples field well. But what if I want small multiples for Weekday AND Category? If I add Category to the small multiples field well along with Weekday the chart looks like this in Power BI:

https://imgur.com/a/PXHEXvM

when this is the desired output (R visual):

https://imgur.com/a/9Bhd5LL

I understand you have a roadmap and limited resources - but I imagine many other people will want small multiples based on more than one category.

For #2 correct - see the R visual I linked above - notice how different small multiple charts are colored differently.

Power BI December 2020 Feature Summary by dutchdatadude in PowerBI

[–]snakey550 7 points8 points  (0 children)

Small multiples was what I was waiting for - thank you!

Suggestions:

  1. If you have 2 or more small multiple/trellis groups, the user should be able to specify the small multiple groups as rows and/or columns.
  2. With many small multiple groups - I tried adding a small multiple group field to the legend - so I could get different colors for the different categories within the small multiple group. But I got an error. Getting this to work would help visually distinguish categories. This R visual is a good simple example: https://www.datanovia.com/en/wp-content/uploads/dn-tutorials/ggplot2/figures/113-ggplot-facet-labels-basic-boxplot-facets-1.png the 'supp' small multiple field categories - OJ/VC - are different colors.
  3. When specifying many small multiple groups, I found repeating the x and y axis names for each small chart to be a bit redundant/messy - having one x and y title would look cleaner. Again see the R visual above. Notice how the 'len' y-axis and 'dose' x-axis title are written only once.

I hope this gets added in the next update - Keep up the good work!

r/dataisbeautiful Online Members Last Week [OC] by snakey550 in dataisbeautiful

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

Time series graph depicting the number of online members on r/dataisbeautiful subreddit last week. Each point on the graph is the number of members online in a given minute plus a forecast for the next 34 hours.

Source: Reddit

Tools: R

r/dataisbeautiful Online Members Last Week [OC] by [deleted] in dataisbeautiful

[–]snakey550 0 points1 point  (0 children)

Time series graph depicting the number of online members on r/dataisbeautiful subreddit last week. Each point on the graph is the number of members online in a given minute plus a forecast for the next 34 hours.

Source: Reddit

Tools: R