cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Select date of alternate Day

Hi,

I am new to Power BI. I am trying to create a DAX to select the date of alternative Thursdays.  Could you please help me to solve the problem?

For Example:

 1.JPG

 

From the above figure, I want to select only alternate Thursdays as shown below. Appreciate your help. 

1/3/2019

1/17/2019

1/31/2019

2/14/2019

2/28/2019

3/14/2019

3/28/2019

4/11/2019

4/25/2019

Sample Date data from January through March

1/1/2019
1/2/2019
1/3/2019
1/4/2019
1/5/2019
1/6/2019
1/7/2019
1/8/2019
1/9/2019
1/10/2019
1/11/2019
1/12/2019
1/13/2019
1/14/2019
1/15/2019
1/16/2019
1/17/2019
1/18/2019
1/19/2019
1/20/2019
1/21/2019
1/22/2019
1/23/2019
1/24/2019
1/25/2019
1/26/2019
1/27/2019
1/28/2019
1/29/2019
1/30/2019
1/31/2019
2/1/2019
2/2/2019
2/3/2019
2/4/2019
2/5/2019
2/6/2019
2/7/2019
2/8/2019
2/9/2019
2/10/2019
2/11/2019
2/12/2019
2/13/2019
2/14/2019
2/15/2019
2/16/2019
2/17/2019
2/18/2019
2/19/2019
2/20/2019
2/21/2019
2/22/2019
2/23/2019
2/24/2019
2/25/2019
2/26/2019
2/27/2019
2/28/2019
2/1/2019
2/8/2019
2/15/2019
2/22/2019
2/2/2019
2/9/2019
2/16/2019
2/23/2019
3/1/2019
3/2/2019
3/3/2019
3/4/2019
3/5/2019
3/6/2019
3/7/2019
3/8/2019
3/9/2019
3/10/2019
3/11/2019
3/12/2019
3/13/2019
3/14/2019
3/15/2019
3/16/2019
3/17/2019
3/18/2019
3/19/2019
3/20/2019
3/21/2019
3/22/2019
3/23/2019
3/24/2019
3/25/2019
3/26/2019
3/27/2019
3/28/2019
3/29/2019
3/30/2019
3/31/2019
1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

See attached file. Created 4 calculated columns:

 

Week = WEEKNUM([Date])

Weekday = WEEKDAY([Date],1)

IsThursday = IF([Weekday] = 5,TRUE(),FALSE())

IsSelectedThursday = IF([IsThursday],IF(MOD([Week],2)=1,TRUE(),FALSE()),FALSE())

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Greg_Deckler
Super User IV
Super User IV

See attached file. Created 4 calculated columns:

 

Week = WEEKNUM([Date])

Weekday = WEEKDAY([Date],1)

IsThursday = IF([Weekday] = 5,TRUE(),FALSE())

IsSelectedThursday = IF([IsThursday],IF(MOD([Week],2)=1,TRUE(),FALSE()),FALSE())

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors