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.
Hi,
I created a comparison chart for this financial year and same month last year. Our financial year starts from Apr. Below is the chart shows the comparison but I would like to remove the months such as Nov 2022, Dec 2022, as we are only in Oct 2023. Any suggestions?
Below is what I would like to see
Solved! Go to Solution.
I am hoping you are using a date table
Try
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
or
Year behind Sales = if( Max(Date[Date]) <= today() , CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date])) , blank())
I used the second one and it works beautifully. Much appreciated!
I am hoping you are using a date table
Try
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
or
Year behind Sales = if( Max(Date[Date]) <= today() , CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date])) , blank())
User | Count |
---|---|
98 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |