Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have used the calculate function along with switch to use multiple criteria against the same field value as below :
H1 = calculate(sum('ytd dec''16'[VALUE]),switch('ytd dec''16'[MONTH],"jul",true(),false()))
but this formula does not seem to return any value - i intend to extend it to several other filters and was testing the formula with just one month as the criterion
can I get some urgent help on this? thank you
Solved! Go to Solution.
Sean - thanks. I solved the problem with your help.
Have you tried a different month? (Do you have any Filters/Slicers maybe excluding the July values?)
I assumed this is a typo => H1 = calculate(sum('ytd dec''16'[VALUE]),switch('ytd dec''16'[MONTH],"jul",true(),false()))
Sean,
I guess we are separated by a few time zones so my delay in checking your reply. Thanks for the quick revert. As for your queries :
1. I have used no slicers and hence Jul is not sliced out
2. Have tried using different months too, with the same result - in fact I want to sum all values for the year 2015, if the months match any of jul till dec
3. H1 - is the name of the measure, which is my given name to identify this measure
4. Are you able to spot any typo in my formula? The formula reported no error, by the way
any help highly appreciated
thanks again
The formula works fine for me!
I marked the quotes in red above because I had to remove those when testing.
I was getting a message that this is not allowed in the Name of a Table when I tried to rename a table in PBI.
However I just tested Importing a table that has " in the Name and that was fine!
But again the Measure works for me!
EDIT: The Warning Message actually only shows up when you try to Rename a Table!
Sean - thanks again. Wondering if the formula is working for you, why is it not returning any value for me?
would attaching the file itself help?
Sean - i will check without the swicth as per your advice.
Is there a place I can send the data to?
You can upload the file to OneDrive or Drop Box and share the link here
Sean - thanks. I solved the problem with your help.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
103 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
99 | |
83 | |
63 | |
54 |