Marialena has attended:
Excel Power Query course
Power Pivot
Hi there,
I am trying to put an "if min" statement in the power pivot but with more than two min statements but it gives me an error since it only accepts 2 statements. How can I resolve the issue?
Thanks,
Marialena
RE: Power Pivot
Hi Marialena,
Thank you for the forum question.
Yes If is limited in Power Pivot. You will have to use Switch.
Below you will find a link to Microsoft's website explaining the Switch function.
https://learn.microsoft.com/en-us/dax/switch-function-dax
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector