Forum Discussion
Calculate backlog over past time
Hi patrickmlsk ,
I have updated your sample pbix file, please check whether that is what you want.
1. Create a date table
2. Create some measures to get the related backlogs
Best Regards
Super Userpatrickmlsk , Not very clear. But you need a date table, Join to all these dates and one join will active, other will be inactive which you will activate using is the userelationship
https://www.youtube.com/watch?v=e6Y-l_JtCq4
You need to check blank date using isblank(Table[Date])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you for your response! The date table with a userelationship could work. However, I still struggle to get the measures correct.
I included a very light pbix with the data and an example how I did show the backlogs with visual filtering.
Here you can find the pbix: https://drive.google.com/file/d/1w9cdV6QJ6AU_0bq1xJzCs7R9NViAUwtF/view?usp=sharing
