Forum Discussion
Alex_Ooi
Helper IV
Helper IVUsing 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...
v-lili6-msft
Community Support
Community Supporthi Alex_Ooi
Since [Campaign Start Date], [Campaign End Date] are different columns in a table, for this case, it usually needs a separate date table (that don't create any active relationship with other tables)as a slicer. see this similar post:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
If you still have the problem, could you please use dummy data to create a simple sample pbix file and share it and your expected output for us have a test.
Regards,
Lin
Alex_OoiHelper IV
Helper IVv-lili6-msft thank you for the tutorial. In my case, I am using values between 3 tables, which I suppose being the major reason of the difficulty I am facing now. I will try to merge my queries and attempt your solution. Hope it works!