Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Need to calculate YTD Average and LYTD Average in DAX , Our Fiscal year starts from Apr. So if my current day is 5th of the June 2017 then lytd_AVG would be from Apr to June would be (MTD Aprn 17) + (MTD May 17) + (MTD June 17)/3
and LYTD_AVG would be (MTD Apr 16) + (MTD May 16) + (MTD June 16)/3
Can you post some sample/example data? Don't really want to have to type out a ton of data to get you the answer.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |