Search:

Type: Posts; User: RicoS; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Weird bug in PowerQuery hyperlink generation?

    Just remove the quote from the hyperlink in the power query formula and it will return the correct hyperlink formula as text. Then in VBA, just use:

    Range("yourQueryTableName[Photo - Account...
  2. Re: Looking for a more efficient formula using a criteria range in an SUMIF Formula

    That formula works for me. Are your 8000 series values formated as text as opposed to number? If so you could use:

    =SUMIF($E$4:$E$100,"80*",$Q$4:$Q$100)
  3. Thread: Formula Problem.

    by RicoS
    Replies
    8
    Views
    152

    Re: Formula Problem.

    Oops, I just made the same mistake as you!
    </e20,"l"))))>
    =IF(OR(E19="",E20=""),"",IF(E19 > E20,"W",IF(E19=E20,"D",IF(E19 < E20,"L"))))
  4. Thread: Formula Problem.

    by RicoS
    Replies
    8
    Views
    152

    Re: Formula Problem.

    Hi,

    Something like this?

    <=IF(OR(E19="",E20=""),"",IF(E19>E20,"W",IF(E19=E20,"D",IF(E19<E20,"L"))))>
  5. Replies
    4
    Views
    501

    Re: Relative Period Filter

    Yes, I see, I did wonder if there were more "phases" of an affilliate's lifecycle. You'd probably need a fact table of affiliate statuses with from and to dates or something in that case. It'd make...
  6. Replies
    4
    Views
    501

    Re: Relative Period Filter

    I'm not suggesting that I have a better method, but I was intrigued as to why you didn't introduce a "Became Member" date (or period) that you could use your measures on? Also, you mentioned a...
  7. DAX measure to get rate from dislocated table

    Hi,

    I am struggling to return a result with a Dax formula. I have a Fact table that has some data

    Fact Table
    <tbody>
    Date
    Account
    Curr
    Trans Amt
Results 1 to 7 of 7