Separate Dynamic Dax Table for averages

[Anonymous]

Hi

Dax is not my strongsuit...

I have data that looks kind of like this:

I created a date table using:

Date = CALENDAR(Date(2019,1,1), TODAY())

1. I'd like to create one separate table that looks like this:

2. Would it be possible to also do this by week? So a similiar view, but the leftmost column would be the week. So if the completion date fell within that week it would be used in the aggregation?

Hope this question makes sense, help very much appreciated!!

[Anonymous]

@parry2kI can't post the information online. I removed the table A vs. table B. (I've been asking lots of questions about this data and using the same pictures, but that isn't the crux of what I'm asking -- let me know if you still need more clarification!

[parry2k · Accepted solution]

@Anonymous solution is attached, hope this helps to get you started.

[parry2k]

@Anonymous type  A and type B, are those two different tables and you want to see those seperately? Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.