Forum Discussion
Alex_Ooi
6 years agoHelper IV
Using measures to return data grouped by specific date ranges
Hi folks, I want to create a measure called Total Bookings by Campaign Period, which I am stuck at the moment. The closest I could get to this is using the measure below: Overall # Bookings = CALC...
Alex_Ooi
6 years agoHelper IV
Oh dear heavens, v-lili6-msft thank you for figuring out what was wrong with my date hierarchy! That's amazing!!
To reply to your first question, no I am expected to populate the whole field, and not just the first row. I was only able to demonstrate the "reconciliation" using date filter for the first row since different campaigns run on different dates.
Please advise.
Alex_Ooi
6 years agoHelper IV
Hi v-lili6-msft can I check with you if my reply to you on your question was clear? I am still hoping that someone can provide a solution.