Results 1 to 3 of 3

Thread: Excel formula to Power BI DAX
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2017
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel formula to Power BI DAX

    Hi everyone,

    I have this formula on Excel and I would like to transform to Power Bi, I have already tried but with no success. Could anyone help me?

    Formula Excel
    =SUMPRODUCT((COUNTIFS(M3:M16,M3:M16,N3:N16,P3-1)=0)* ((N3:N16=P3)+(N3:N16=P3-1)))

    Thanks!!!
    Last edited by RodrigoFinguer; Feb 1st, 2019 at 12:00 PM.

  2. #2
    Board Regular
    Join Date
    Nov 2016
    Posts
    106
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel formula to Power BI DAX

    Unless someone is smarter than me would me it help if if you provided sample data with expected result.
    Last edited by peter789; Feb 1st, 2019 at 03:15 PM.

  3. #3
    Board Regular
    Join Date
    Jun 2017
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel formula to Power BI DAX

    Quote Originally Posted by peter789 View Post
    Unless someone is smarter than me would me it help if if you provided sample data with expected result.
    Sorry, Take a look at this my other thread: https://www.mrexcel.com/forum/excel-...s-dates-2.html

    Look at the post #19

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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