DistinctCount Previous Quarter - Help

[agd50]

Would anyone have any idea what I've done wrong here?

 CALCULATE (

     DISTINCTCOUNT ( 'Table'[Column]),

     PREVIOUSQUARTER ( 'Table'[Date]

 ))
It doesn't give me the right number although it's possible that it is correct, just need another opinion.

Thanks,
Andrew

[amitchandak · Accepted solution]

@agd50 , always use a date table in such cases

CALCULATE (
DISTINCTCOUNT ( 'Table'[Column]),
PREVIOUSQUARTER ( 'Date'[Date]
))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0