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?
From the above figure, I want to select only alternate Thursdays as shown below. Appreciate your help.
Sample Date data from January through March
Go to 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())
Proud to be a Super User!
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.