Forum Discussion
Solved
Showing data between two dates
Hey All, I have a contracts table, where I have the start date and end date. I also have the monthly amount. When I connect my calendar table to the end date and put that data into a matrix, ...
ViniNaegele
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
ViniNaegele
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Thanks, the period billing measure worked!
Do you know what would need to be changed if the calendar table was already connected to the billing table?
