I have attached a simple table showing what I'd like to achieve but without using the calculated column,
essentially, I just used and if statement and then summed the result in a measure,
Please Login or Register to view this content.
I'd like to do the whole thing in a measure , but it proved more tricky than I'd have thought, I've tried using datesbetween,
Any suggestions on best way to achieve this welcome,Please Login or Register to view this content.
Richard.
Bookmarks