Results 1 to 3 of 3

Thread: Conditional Power Query formulas

  1. #1
    Neophyte phattails's Avatar
    Join Date
    Jan 2016
    Posts
    4
    Articles
    0
    Excel Version
    Office 365 pro plus

    Conditional Power Query formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Let's say that I have multiple queries that I want to only run if a condition is present in my parameter table. So, I decide to create functions from my queries with the idea of creating another function that invokes the relevant queries if the condition is present. With that being said, I have another Query that returns a table (let's call this table Relfunctions) of the functions and their names that I want to run given my conditions indicated in my parameter table. So here's my question: how do I use table Relfunctions to invoke these individual functions? Can you think of a better way to set this up?

    Thanks,
    PT

  2. #2
    Acolyte El Cid's Avatar
    Join Date
    Aug 2016
    Location
    Greenville, SC
    Posts
    46
    Articles
    0
    Excel Version
    Excel 2016

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,203
    Articles
    0
    Excel Version
    Office 365 Subscription
    Thread moved to correct sub-forum.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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