The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello, I am looking for some urgent help in fixing a DAX measure please.
I am essentially trying to create a measure using the IF Function based on what Month has been filtered on in the dashbaord, eg) if Jan is selected i want one formula to be used and if September is selected i want a different formula to be used.
I have the formulas for a False & True result from the if function ready but the trouble I am having is building the If Function formula and linking that to the Month table in the query, here is what I have so far when practicing with January, note I also tried "Jan";
Hi @Anonymous - use SELECTEDVALUE on the month.
Measure =
SWITCH( SELECTEDVALUE(Month[Month]),
"Jan", FormulaA,
"Feb", FormulaB,
...
)
SWITCH also helps you by not having imbedded IF statements. Here is a good site to help you with the language: https://dax.guide/ . It can give you more info on the functions mentioned here.
Hope this helps
David
Great thank you so much!!
Just one more follow on query please..
I'm playing around with the formula as i'm trying to get the first half of the year to have one result and the second half of the year to have a different result, i've tried this but it doesn't work:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
115 | |
33 | |
30 | |
24 | |
21 |