Pulling data points for one day each week over the last 52 weeks

[Anonymous]

Good Afternoon,

I have been given a request to show production data for every Wednesday for the last year. Is there a dax formula that I could use to isolate these data points? 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Do you have a week day column in your table? If so, you can try a measure like below

wednesday value = CALCULATE ( SUM ( 'Table'[value] ), 'Table'[week day] = "Wednesday" )

If you only have Date column, you can use this measure

wednesday value =
CALCULATE (
    SUM ( 'Table'[value] ),
    FORMAT ( 'Table'[Date], "dddd" ) = "Wednesday"
)

or

wednesday value = CALCULATE ( SUM ( 'Table'[value] ), WEEKDAY ( 'Table'[Date], 2 ) = 3 )

If this doesn't work, can you please share some dummy data and expected result to show the output you want to get?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.