Using 3 dates as values in power BI

[Dan27]

Hello

I'm hoping someone can help. Let me set the scene. I'm trying to pull together a line chart for last year. In the data I'm using I have 3 date fields. One called date received. One called date open and one called date closed.

Each of these are dd/mm/yy format. On the X axis I'd like to have the weeknum. I'd like to show the number of each of the aboth for each week.

I've tried quite a few different ways but I always get the same volume for each received, opened and closed which isn't right. I think this might be because I'm using count of?

Can anyone help me get around this.

Thanks

[v-jiascu-msft]

Hi @Dan27,

Can you share a dummy sample please?

Best Regards,

Dale

[Dan27]

Hi Dale

Thanks for your offer of help. I've uploaded a sample spreadsheet of what I'm trying to do. Columns A-C are what data I have in Power BI. Columns D-F are formulas that I'm unsure how to create in Power BI if I even need to and Columns H-M are also formulas giving me the output I'd like in Power BI if possible.

If you can help me I'll be forever indebted to you!!!!

I've had to create as images. I've done one showing the data and one showing formulas I've used in excel to achieve.

Thanks

Dan

[v-jiascu-msft]

Hi Dan,

If it's convenient for you, please share the pbix file directly. You can upload it to a cloud drive like OneDrive, GoogleDrive and then share the download link here. Please mask your private information first.

Best Regards,

Dale