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.
Hi guys,
I have table with a coumn vor a value and a date table.
Now I'd like to multiply the value with 13 when in date slicer selected month is Jan to October..
When November and December is selected I'd like to multiply the value *12
May you help me out with this thing?
Thank you very much in advance?
David
Solved! Go to Solution.
@Anonymous
[Value]*(13-IF(MONTH([Date]) IN {11,12},1,0))
Hello @lbendlin
Thank you very much! Have tried a lot around with IF before to get the solution. Now I understand my problem better. Using IF I have to create a column. But at moment I don't have access to tabular model which I use for report.
Is it possible to get the expected value (basisvalue x *12 when month is 1,2,3,4,5,6,7,8,9,10, and *13 when month is 11,12) on another way?
This should work in a measure too.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |