Get value of every friday from date column

[ApurvaKhatri]

I have a date column [AsofDate] in a table table1. I needto calculate value of amount on every friday of every month fom [AsofDate] Column.

How do I acheive that?

[Vvelarde · Accepted solution]

@ApurvaKhatri

Hi, Create a measure

Amount-Fridays =
CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER ( Table1, WEEKDAY ( Table1[Date] ) = 6 )
)

Regards

Victor

Lima - Peru

[fhill]

Use the WEEKDAY function as either a FILTER (6 is Friday by default for US power BI, but double check your version), or add a Custom Column of WEEKDAY in your Date Master Table (or you local Dates if you don't have a Date Master) and Filter / Slice out in PowerBI.

FOrrest