Forum Discussion

Jeffuh's avatar
Jeffuh
New Member
4 years ago
Solved

Creating a Filter for a Specific Week

Good Evening:   I am trying to create a report that shows historical data for sales for a specific week, in this case Mother's Day.  My report has all the sales data for each year, so I am trying t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Jeffuh,

    You can create a  calculated column with the following formulas to check the Second Sunday of May and return the tag:

    2nd Sunday of May=
IF (
    //the second week of May
    WEEKNUM ( Table[Date], 2 )
        = WEEKNUM ( DATE ( YEAR ( Table[Date] ), 5, 1 ), 2 ) + 1
        && //sunday
        WEEKDAY ( Table[Date], 2 ) = 7,
    "Y",
    "N"
)

    Regards,

    Xiaoxin Sheng

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Jeffuh 

 

You can create a Date Table, and add a column to it as a Mother's Day column, and add YES to those dates you want to be included to your report and NO for other dates.

Then, use this Date table and Mother's Day column to filter your report.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/