Home › Forums › Power Pivot › IF statement regarding date

Tagged: 

This topic contains 16 replies, has 2 voices, and was last updated by  tomallan 6 years, 7 months ago.

Viewing 2 posts - 16 through 17 (of 17 total)
1 2
  • Author
    Posts
  • October 6, 2017 at 3:48 pm #8399

    KCantor
    Participant
    • Started: 13
    • Replies: 30
    • Total: 43

    Tom,

    It is a beautiful work of art that refreshes quickly. It also works well in the YoY attrition calculation.

    Your help is appreciated and I always enjoy working with you.

    Kristi

    October 6, 2017 at 5:30 pm #8400

    tomallan
    Keymaster
    • Started: 0
    • Replies: 417
    • Total: 417

    Kristi,

    You are welcome!

    I will also extend your thanks to my associate who helped me see an opportunity for optimization (replace the combination of SUMX and DISTINCTCOUNT).

    Best regards,

    Tom

  • Author
    Posts
Viewing 2 posts - 16 through 17 (of 17 total)
1 2

The forum ‘Power Pivot’ is closed to new topics and replies.