Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to conduct the following calculation:
For example - On Q2-2018 there was a total income of 36 , out of which 24 was contributed by clients that started in the last 12 months (Q3-2017).
So generally - I'm trying to know how much income did each client contribute in the last 12 months.
I have date tables and Quarterly start dates on my tables so they can be used.
I made a bunch of attempts that failed, so I guess I'm missing a key piece of knowledge.
I'd really appreciate any help you could offer,
Thank you,
Ohad
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |