making dax expression to find the number of friday days

[waleed55]

my date cell look like this 5/23/2023 6:17:08 AM and i want to get the number of friday in this data column how can i do that

[foodd · Accepted solution]

To calculate the number of Fridays in a date column

using DAX WEEKDAY() Function 

=COUNTROWS(FILTER(tgif, WEEKDAY(tgif[Date], 2) = 5))

This formula counts the number of rows in a table that have a date with a weekday of 5 (Friday). In this formula, `tgif` is the name of the table, and `Date` is the name of the column that contains the dates.

[waleed55]

i mean week day i want to calculate the number of fridays in data column

[Ahmedx]

Is this what you are looking for?