Home › Forums › Power Pivot › Multiple IFs in DAX This topic contains 3 replies, has 3 voices, and was last updated by DarioKeizer 7 months, 1 week ago. Viewing 4 posts - 1 through 4 (of 4 total) Author Posts September 13, 2018 at 7:25 am #10592 DarioKeizerParticipant Started: 1Replies: 1Total: 2 Hi Everyone, I am busy migrating all my department’s reports to PowerPivot using DAX. In one of the reports I use a function with multiple IFs so that: – for each row containing a number, the corresponding word (e.g. X-Large, Large, Medium) is returned. Does anybody know which DAX expression(s) I can use to achieve this. I was thinking about calculate in combination with count…but didn’t achieve the result just yet. Attachments:You must be logged in to view attached files. September 13, 2018 at 11:11 am #10595 jhdParticipant Started: 1Replies: 8Total: 9 Have you had a look at SWITCH? https://powerpivotpro.com/2012/06/dax-making-the-case-for-switch/ September 19, 2018 at 3:02 pm #10649 infinitex86Participant Started: 3Replies: 9Total: 12 As jhd pointed out — SWITCH is the way to go. Much more readable than nested IF statements. To rewrite your formula in DAX, simply use: = SWITCH([Column B], 1, “XLarge”, 2, “Large”, etc, etc) September 21, 2018 at 12:35 pm #10661 DarioKeizerParticipant Started: 1Replies: 1Total: 2 Hey jhd and infinitex86, Thanks for your answers. This was exactly the solution I was looking for, Gr. Dario Author Posts Viewing 4 posts - 1 through 4 (of 4 total) You must be logged in to reply to this topic.