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.
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!
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 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |