Forum Discussion
BItoken
Helper III
Helper IIIQOQ Distinct Accounts calculation
Hi All, We have started collecting data since the last 2 quarters on accounts and we have a rolled up date field which is date for the Quarter end and im trying to get the QOQ for the current quarter...
amitchandak
Super User
Super UserBItoken , if you have a date you can use a date table and use DatesQTD formula.
Else you have to opt for the Rank way
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
BItokenHelper III
Helper IIIthe rank func does not work.
Is it because im deiving the Q from the end date which is already rolled up to show just one date (End of Qtr)