Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there,
I need to create a dynamic measure that will do next:
1. if the date is current month , then
YoY sales = (Sales/ ((Sales LY / number of days in the months) *number of days Months to date)) -1
otherwise
YoY sales = calculate(divide([sales],[Sales LY]), -1)
I used the below dax to get the number of days in the months
Hi @Tani4ka ,
If you can share a pbix file with some sample data, people would be easily able to help you much quicker
User | Count |
---|---|
128 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |