Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi,
I have a question regarding a measure that is not working properly.What i want to achieve is if current month is jan, feb or march, then do sum( sales1a and sum of sales1b), if current month falls under month april, may, june then use sales2, but for some reason the measure is not working. This is what I have :
if you see measure 2, doesnt add up for some reason sales 1a and sales 1b and second it gives values, although it should only give values when current month falls under one of those months.
@userdata , Try a measure like
Switch(True(),
MONTH(today()) <4, ([sales1a]+[sales 1b]) ,
MONTH(today()) <7, ([sales2a]+[sales2b])
)
Thanks for the reply but that wont solve it because the issue is that it will calculate sales 1a and 1b only if its bigger than.It gives me the same values as the above formula. The thing I want to achieve is if current month falls under month 1,2 or 3, then do sales1a and sales1b, if current month falls under month 4,5,6 then do sales2a and sales2b, otherwise 0 . I tried an or function but that gave me errors. I think maybe I have to define curren month differently?
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
21 | |
13 | |
12 |
User | Count |
---|---|
43 | |
28 | |
25 | |
23 | |
22 |