Forum home » Delegate support and help forum » Microsoft Excel Training and help » Power Pivot

Power Pivot

ResolvedVersion 365

Thu 20 Oct 2022, 12:15 Delegate Marialena said...

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

Thu 20 Oct 2022, 16:56 Trainer Jens said...

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

Fri 21 Oct 2022, 15:08 Delegate Marialena said...

RE: Power Pivot

Great thank you!

However, I want to do calculations in it, so I used SWITCH(TRUE,...) but it gives me an error for the syntax of [value] which I cant remove.

Could you please help me with that?

Thanks
Marialena

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Power Pivot

Power Pivot

RE: Power Pivot

RE: Power Pivot

Excel articles

Excel tip:

Quickly create a list of numbers