Forum Discussion

m3awadhi's avatar
m3awadhi
Frequent Visitor
7 years ago
Solved

Aggregation not working when using Date Table

Hello everybody,
I have two tables in my model ,first  table is Calculated  Dates Table .
Second table is Requests Table as shown below,
Both Tables have Year Field, 
Everything is working as expected when I do aggregation based on year field from Requests Table.

But aggregation is not working when i use Year Field from Dates table,
I have attached pbix  and  excel file,
RequestsDev.pbix
Requests.xlsx
Kindly check 
Thanks

  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    Hi@ m3awadhi 

    After my research , you need to and a new column and create the relationship between Requests and Dates by 

    the new column and date instead of CreatedOn and date like below:

    Column = DATEVALUE(Requests[CreatedOn])

    Result:

    Best Regards,

    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    Hi@ m3awadhi 

    After my research , you need to and a new column and create the relationship between Requests and Dates by 

    the new column and date instead of CreatedOn and date like below:

    Column = DATEVALUE(Requests[CreatedOn])

    Result:

    Best Regards,

    Lin