Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Our sales team receives a report every week showing the YTD, Last Year YTD, MTD and LY MTD sales, but they would like to see the sales of the whole current month of last year instead of MTD.
Does anyone know how I could do that in a dynamic way?
Solved! Go to Solution.
If you want to calculate same month last year total, you just need to use PARALLELPERIOD() function and set the interval on month level.
= CALCULATE(SUM('Table'[Amount]),PARALLELPERIOD('Table'[Date],-12,MONTH))
Regards,
If you want to calculate same month last year total, you just need to use PARALLELPERIOD() function and set the interval on month level.
= CALCULATE(SUM('Table'[Amount]),PARALLELPERIOD('Table'[Date],-12,MONTH))
Regards,
Hello,
I am fairly new to Power BI so bear that in mind. You could create a column that looks at the month you're in and marks the data in or out. If your data set is updated each day with the current sales it would show the total current months sales for each year and only (Obviously) the MTD sales current year.
Step 1: Create new column.
Step 2: Paste the following DAX: IsCurrentMonth = IF(MONTH(Sales[Posting Date]) = MONTH(TODAY()); "Yes"; "No")
Step 3: Filter the page or visuals with the column "Yes".
I hope this is the answer you are looking for.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |