Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I'm trying to create what should be a pretty simple calculated column but need to compare more than 2 values which I am limited to with the OR Function. I've tried using double pipe as well as the IN function and cannot seem to get any of those to work!
My goal is to evaluate Opportunity[CreatedDate] against the YEAR and then evaluate Opportunity[CreatedDate] against the MONTH to determine if the CreatedDate falls within the CY quarter.
Any help would be greatly aprreciated!
Mike
This is what I have tried so far:
#1
IsCurrentQtrCreated = IF ( YEAR ( Opportunity[CreatedDate] ) = YEAR ( TODAY () )
&& (MONTH ( Opportunity[CreatedDate] IN {10,11,12}),
"YES",
"NO"
))
#2
IsCurrentQtrCreated =IF ( YEAR ( Opportunity[CreatedDate] ) = YEAR ( TODAY () )
&& OR (MONTH ( Opportunity[CreatedDate] = 10 || Opportunity[CreatedDate] = 11 || Opportunity[CreatedDate] =12 ),
"YES",
"NO"
)
Here's the hard coded version of your code working. Did you want to intergrate TODAY() so it roates automatically?
CurrentQtrCheck = IF(YEAR(Query1[StartOfMonth]) = YEAR(TODAY()) && (MONTH(Query1[StartOfMonth]) = 10 || MONTH(Query1[StartOfMonth]) = 11 || MONTH(Query1[StartOfMonth]) = 12), "YES","NO")
Proud to give back to the community!
Thank You!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 82 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |