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...
BItokenHelper III
Helper IIIHi @amitchandak
Thanks for your response.
I already have the Quarter infor derived from the end of period date which is "FQ" so not sure how the calcs you mentioned will help here. Also, our FY Q1 starts in April to June and FY Q4 ends in Jan to March.
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
- BItoken
the 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)