Forum Discussion

Mokhtar's avatar
Mokhtar
Frequent Visitor
6 years ago
Solved

Difference Between Quarter display wrong values

Dear Power BI Comunity, I want to calculate the difference between two dates in quarters. However I'm getting a woring values below a screenshot,   Thanks in advance,
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Mokhtar , 

    I think you could refer to az38 ' s suggestions to check whether you set aggregation on column

     Or you could try below expression 

    Column = 'Table'[end].[QuarterNo]-'Table'[start].[QuarterNo]

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi Mokhtar , 

I think you could refer to az38 ' s suggestions to check whether you set aggregation on column

 Or you could try below expression 

Column = 'Table'[end].[QuarterNo]-'Table'[start].[QuarterNo]

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Mokhtar's avatar
    Mokhtar
    Frequent Visitor
    6 years ago

    Hello,

     

    Thanks for the answer. It was because of the aggregation.

     

    Regards,

    Mokhtar