Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My requirement is get to full year total of selected month or each month like below report, Could anyone help in achieving this.
Thanks,
Ashok Kumar M
Solved! Go to Solution.
You may need a calendar table and measures as below.
currentYearSales = CALCULATE(SUM(yourTable[sales]),ALLEXCEPT('calendar','calendar'[Date].[Year])) lastYearSales = CALCULATE(SUM(yourTable[sales]),FILTER(ALL('calendar'),'calendar'[Date].[Year]=MAX('calendar'[Date].[Year])-1))
See more details in the attached pbix file.
You may need a calendar table and measures as below.
currentYearSales = CALCULATE(SUM(yourTable[sales]),ALLEXCEPT('calendar','calendar'[Date].[Year])) lastYearSales = CALCULATE(SUM(yourTable[sales]),FILTER(ALL('calendar'),'calendar'[Date].[Year]=MAX('calendar'[Date].[Year])-1))
See more details in the attached pbix file.
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |