+ Reply to Thread
Results 1 to 4 of 4

Power Query list select on each condition true / false

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    758

    Power Query list select on each condition true / false

    Hi, if i have the following ;

    Please Login or Register  to view this content.
    This works fine, so if I wanted a different condition say the last 3 characters are numbers, so as transform;

    Please Login or Register  to view this content.
    This will give a true false in correct position, but I can't get it to work with select ?

    =
    Please Login or Register  to view this content.
    so I've tried various options such as

    Please Login or Register  to view this content.

    What do I need to do ?

    examples attached.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-05-2024
    Location
    Moscow, Russia
    MS-Off Ver
    365
    Posts
    25

    Re: Power Query list select on each condition true / false

    Number.From throws an error when last 3 chars are not numbers.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    758

    Re: Power Query list select on each condition true / false

    Thanks, yes I sort of realized the problem, I know this is not doing any splitting, but just to get the principal I'd tried;

    Please Login or Register  to view this content.
    which does give all true / false results,

    Thanks for taking the time to reply,

    Richard.

  4. #4
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    758

    Re: Power Query list select on each condition true / false

    Hi,
    just to understand, try bring back a record,
    Please Login or Register  to view this content.
    and has error wouuld be fasle, but using Not = true and so selected, oh, and thanks for split by whit space, never noticed
    than before,

    Richard

+ 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. Power BI - True/False Values not Conditional Formatting Correctly
    By micky007 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-08-2020, 06:49 AM
  2. Power BI - Export Data, Turn 0/1 to True/False
    By micky007 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-06-2020, 10:21 AM
  3. Return False or True with condition
    By stev_2109 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2019, 09:26 AM
  4. Replies: 3
    Last Post: 08-16-2018, 06:07 AM
  5. Power Query - calculated true or false show result of table????
    By janljan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2018, 11:23 PM
  6. Replies: 2
    Last Post: 06-29-2014, 10:11 AM
  7. If True/False Condition
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-04-2012, 05:18 PM

Tags for this Thread

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