Forum Discussion
Solved
DAX formula
I have a table of accounts were is have a column Placed Date and a column Payment Date. I added a column and used a
List to Payment Days = DATEDIFF(Debtor[Placed Date], Debtor[Payment date],DAY). I get the correct number from this. Now I am trying to see how many accounts have List to Payment Days greater than 30. I added a column and used
List to Payment Days 30 = IF(SUM('Debtor'[List to Payment Days]) > 30, 1, 0). It is giving my a 1 on every account. I need to know were I went wrong.
Thank you
HI ccubs2331 ,
REmove SUM
List to Payment Days 30 = IF(Debtor'[List to Payment Days] > 30, 1, 0)
https://www.youtube.com/watch?v=03E0f-RyRn4
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
1 Reply
HI ccubs2331 ,
REmove SUM
List to Payment Days 30 = IF(Debtor'[List to Payment Days] > 30, 1, 0)
https://www.youtube.com/watch?v=03E0f-RyRn4
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)