Distinguish skipped from non-answered questions

[Kal_Lam]

@naledi_h, maybe this post discussed previously should help you understand how a skipped question is handled in Power BI:

Pulling data into Power Bi via API: Skipped questions at set up not added when answered post set up

Hi For capturing baseline data and recurrent updates, we have created a questionnaire (xlsform) which has become quite complex by now. There is a lot of skip logic and repeats – for instance, capturing either data on a school or data on a ECD centre, as well as asking for the number of preprimary classes and then for enrolment numbers of each of them. Janna’s wonderful youtube tutorial (https://www.youtube.com/watch?v=mDokTnjM6Fo&t=518s) worked perfectly to get the data from kf.kobotoolbox.org …