Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear: I need your help with time intelligence and groupings, I explain:
I have a sales data with 5 years of example, I want to compare a period of time of current sale with its similar of a previous year (for the example it is by year), that is to say if I choose the sale 2022, I can compare between the sale 2021 with 2022.
But it turns out
That the client wants it not to be used for years but for periods of time being the periods of time
Taking as last month June 2022 | |
YTD | January to date (June 2022) |
FOOD | Last mobile year (Jul 2021-Jun 2022) |
MTH | Last month (Jun 2022) |
QTR | Last quarter Q2 (Apr, May, Jun), being Q1 (Jan, Feb, Tue) |
QTRM | Last mobile quarter if month is Jun would be May, Apr, Sea |
In the example instead of year I must choose period according to the previous table.
Thank you in advance for the help you can give me
Sample File
https://drive.google.com/file/d/1Bk5NH033w-miDjMqNRh5Bki6y_9dQ91N/view?usp=sharing
thanks for the answer, but it's not what I need.
Best regards
@Syndicate_Admin , Not very clear
refer
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |