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:
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
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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
