Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear,
I would like to get the formulae to get a KPI of the sales of the YTD until the month filtered.
I am doing a fiscal Year that goes from 1st October until 30th September.
Could you help me with the formula?
Thanks,
Kind regards,
Hi @Anonymous,
I'd like some sample data and expected result to help us understand your data structure and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Give me some days, i will publish. Thanks
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...
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |