Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey there,
Is there any way to help to pinpoint Year & Month (format look like: January 2024) For example, I want to flag 'Y", as long as Year and Month = 'January 2024', but it also bring the data with 'Feburary 2024 there'. I know I can use say year & month with number (Year * 100 + Month). But just curious whether there are some ways for me to directly do condition for year and month with date format directly? Thanks!
Solved! Go to Solution.
maybe you can try
if( [year and month]= "January 2024", "Y')
or
if (format([date],"mmmm")&" "&year([date])="January 2024", "Y')
Proud to be a Super User!
I'm only understanding half of this question.
If you want to test a date use the YEAR and MONTH DAX functions.
If you have a problem with the LOOKUPVALUE returning values in February when they should be in January, show us the rows that are returning February (wrongly) and show us the Time_lookup table.
maybe you can try
if( [year and month]= "January 2024", "Y')
or
if (format([date],"mmmm")&" "&year([date])="January 2024", "Y')
Proud to be a Super User!
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |