Forum Discussion
Finding Date of First Non Zero Value
Hello All , Thank you for supporting a new user. I am creating a visual to compare actual or forecast launch dates (first sales date) for new products compared to budgeted launch date (budge...
Unfortuantely, this does not work. I require the output of the dax to be the date of the month when the first sales are recorded (before which sales where zero).
Hi Anonymous ,
Use FIRSTNONBLANK instead of using FIRSTNONBLANKVALUE. It would give the date for which first sales is recorded (non zero).
Budgeted Launch Date = FIRSTNONBLANK('Street Sales transactional Data'[Date], SUM'(Street Sales transactional Data'[Street Sales Budget Net Sales ($)] ) )
Hope this helps!
Thanks,
Nikita Dalela | BI Consultant
Nice Software Solutions