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.
My calendar table starts on 9/1/2017 and ends on 4/30/2019. I am simply trying create a calculated column that indicates if the date is either in the BASE period or in the TEST period. The BASE period runs from 9/1/2017 to 6/30/2018 and the TEST period runs from 7/1/2018 to 4/30/2019. What is wrong with my calculated column because it returns TEST PERIOD for all the dates including those which are part of the base period?
=if(('Calendar'[Date] >= 9/1/2017 && 'Calendar'[Date] <= 6/30/2018), "Base Period", "Test Period")
Thank you.
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you, works perfectly!
Hello,
You can try this:
=if(('Calendar'[Date] >= DATEVALUE("9/1/2017") && 'Calendar'[Date] <= DATEVALUE("6/30/2018")), "Base Period", "Test Period")
Regards,
ElenaN
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |