Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.