+ Reply to Thread
Results 1 to 3 of 3

If formula for powerpivot

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    If formula for powerpivot

    Hello. Create this formula for powerpivot. Can anyone tell me what is wrong with it? Thanks?

    =if([Channel]= "DIRECT TO CONSUMER","DTC", if([Channel]="DTC - RENEWAL", "DTC Renewal",if([Channel]= "Portfolio Management", "PM",if([Channel]="PORTFOLIO MANAGEMENT - RENEWAL", "PM Renewal", if([Channel]= "Real Estate", "Real Estate", "RE Renewal"))

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,355

    Re: If formula for powerpivot

    Hey,

    I thought upper/lower case was VERY important in Power Queries and the M Language. Does if need to be IF?

    If I remember I always got this wrong as I like "If" but I think it needs to be a lower case "if".

    THEN you need to have the "then" in your "if" statement. It is completely different than the Excel formula. You need to put in the word "then" and "else" if needed.

    http://www.excelguru.ca/blog/2014/09...n-power-query/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Re: If formula for powerpivot

    Oh yeah, forgot about that. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Powerpivot formula help
    By Jo2710 in forum Excel General
    Replies: 0
    Last Post: 06-07-2016, 03:54 AM
  2. Is it possible to use Cube Formula without Powerpivot?
    By liquidmettle in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-30-2015, 01:31 PM
  3. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  4. Error in formula in powerpivot
    By siddharth_s1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-20-2015, 04:07 AM
  5. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  6. Replies: 0
    Last Post: 11-20-2012, 05:34 AM
  7. PowerPivot Measure Formula
    By Twi78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 08:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1