Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Think your IF statement is using incorrect logic, by the looks of thing it's only going to return yes if your return date is exactly the first of the previous month. Why not try something like:
Returned = var todaysdate = today()
if ([recentreturn] = blank(), "no", if (month([recentreturn])=month(todaysdate)&&(year([recentreturn])=year(todaysdate),"yes","reset")
i.e. compare the year and the month of your column to the year and the month of today and see if they both match
Think your IF statement is using incorrect logic, by the looks of thing it's only going to return yes if your return date is exactly the first of the previous month. Why not try something like:
Returned = var todaysdate = today()
if ([recentreturn] = blank(), "no", if (month([recentreturn])=month(todaysdate)&&(year([recentreturn])=year(todaysdate),"yes","reset")
i.e. compare the year and the month of your column to the year and the month of today and see if they both match
hi, @joansinho
Your image file is damaged, please upload again.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |