Forum Discussion
multiple conditions + calculation
Hi Community, following problem. My calculation with multiple conditions including addition does not work Here is my formula that doesn't work: If(and( Category ="Küche" && Order ...
Hi Anonymous ,
Create a column with below code
Column =
SWITCH (
TRUE (),
Category = "Küche"
&& Order > DATE ( 2021, 12, 31 )
&& Order < DATE ( 2022, 12, 31 ), 0 * 200,
Category = "Küche"
&& Shiptment > DATE ( 2021, 12, 31 )
&& Order < DATE ( 2022, 12, 31 ), 0.25 * 200,
Category = "Küche"
&& Shiptment > DATE ( 2021, 12, 31 )
&& Order < DATE ( 2022, 12, 31 ), 0.25 * 200,
Category = "Küche"
&& IBN > DATE ( 2021, 12, 31 )
&& Order < DATE ( 2022, 12, 31 ), 0.5 * 200,
Category = "Küche"
&& Ready > DATE ( 2021, 12, 31 )
&& Order < DATE ( 2022, 12, 31 ), 0.25 * 200
)
and then create a measure like below or directly used new column as summerized as sum
Measure = Sum(table[column])
Thanks,
Samarth
Thanks for your help - Unfortunately it doesn't work.
Syndicate_Admin , Remove last comma(",") from the last line i.e. line 28.
Anonymous is it possible for you to share PBIX file after removing sensitive data?