Getting Z-Score to calculate based off of a "Weekday" Slicer

SSGUY — Fri, 03 Feb 2023 19:32:14 GMT

Z-Score Winter =

VAR _Athlete = 'Data'[Athlete]

VAR _Today = 'Data'[Session Load]

VAR _StartDate = DATE(2023,1,19)

VAR _EndDate = TODAY()

VAR _Average =

AVERAGEX(

FILTER( ALL ( 'Data' ), 'Data'[Athlete] = _Athlete && 'Data'[Date] >= _StartDate && 'Data'[Date] <= _EndDate),

'Data'[Session Load]

)

VAR _sd =

STDEVX.P(

FILTER( ALL('Data'), 'Data'[Athlete] = _Athlete && 'Data'[Date] >= _StartDate && 'Data'[Date] <= _EndDate),

'Data'[SessionLoad]

)

RETURN

(_Today - _Average) / _sd

Hey everyone, working on displaying Z-Scores on a graph, but having some trouble with one part. At some point I want to compare Mondays only to Mondays, and Tuesdays only to Tuesdays, Ect. At this point it is taking into consideration each day of the week and anything between the dates I have specified. I also like to see this, so im just wondering if there is a way to write this so that if i have a slicer with "Weekday" it will recalculate. At the moment, this is a column calc. Just wondering if anyone has a solution here.

Thanks!

Re: Getting Z-Score to calculate based off of a "Weekday" Slicer

amitchandak — Sat, 04 Feb 2023 02:25:16 GMT

SSGUY , if you want to compare with last week day , you can use a measure like with help from dat table

7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

topic Re: Getting Z-Score to calculate based off of a "Weekday" Slicer in DAX Commands and Tips

Getting Z-Score to calculate based off of a "Weekday" Slicer

Re: Getting Z-Score to calculate based off of a "Weekday" Slicer