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 exp...
  • 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

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

  • m3awadhi's avatar
    m3awadhi
    Frequent Visitor
    7 years ago

    Hi  v-lili6-msft

    It is working now 
    Thanks alot,