Forum Discussion
Helper IVUsing measures to return data grouped by specific date ranges
Community Supporthi Alex_Ooi
Don't create a relationship between 'dCalendar' table and 'sales' table.
and if still have the problem, could you please share a simple sampe pbix file for us have a test?
Regards,
Lin
Helper IVHi v-lili6-msft even after following your advise, I am still not able to get the desired output.
Unfortunately, after creating a dummy data, I just realised this forum does not have "ATTACH FILES" feature! Can you please guide me how should I send my data over to you?
- v-lili6-msft
hi Alex_Ooi
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Lin
- Alex_Ooi
Please find the links below for your review.
PromoCodes Dummy Data , Sales Dummy Data , Pbix Test File
Besides this issue, I also noticed that my date hierarchy feature is missing. I raised it up in another thread, but I still haven't received reply. Can you please help me out with that also?
- v-lili6-msft
hi Alex_Ooi
Based on my test on your sample pbix file, do you mean that just the first row will show the data, if so, you could just use this simple formula as below:
Measure = IF(SELECTEDVALUE(PromoCodes[Booking From])=MIN('Calendar'[Date])&&SELECTEDVALUE(PromoCodes[Booking To])=MAX('Calendar'[Date]),[NF # Bookings by Site])Result:
and for why your date hierarchy feature is missing, just enable it as below:
Result:
Regards,
Lin