topic Re: Same month, last year with a slicer on page in DAX Commands and Tips

Same month, last year with a slicer on page

itscaptainmatt — Tue, 23 Apr 2024 14:40:13 GMT

Hi,

I've tried many ways of doing this with sameperiodlast year and the dateadd functions but I can't seem to eliminate the effect of my slicer. I have a slicer that allows me to choose which month and year.

I am able to to total my sales in column 1, pull my sales target in column 2 and have my pace % for current month in column 3. I would like to add my sales of the same month but year selected -1. For column 5 I would like to have Column 1 divided by column 4 (should be ok once I figure out column 4. Example of what I would like:

Re: Same month, last year with a slicer on page

lbendlin — Wed, 24 Apr 2024 00:25:13 GMT

Use disconnected tables to feed your slicers.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Same month, last year with a slicer on page

Anonymous — Wed, 24 Apr 2024 10:07:02 GMT

Hi lbendlin ,thanks for the quick reply, I'll add further.

Hi itscaptainmatt ，

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure

Last Year = VAR _a = SELECTEDVALUE('Table'[Year]) -1 VAR _b = SELECTEDVALUE('Table'[Month]) VAR _c = CALCULATE(SUM('Table'[Sales]),'Table'[Year] = _a,'Table'[Month] = _b) RETURN _c

2.Final output