Hi, I wanted to use the monht nuumber as a true / false criteria in a measure, my starting point was
This gives a count of 1 to 12 in a pivot and works perfectly well with say [TotalSales] / [ALLMONTHS] ,![]()
Please Login or Register to view this content.
but if if try and use it with an IF ;
I get an error, I sort of get why this does not work but is there another ( hopefully simpler) way to get a true / false from the month number,![]()
Please Login or Register to view this content.
ive attached workbook to give some context.
Richard.
Bookmarks