Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Help with Same Period Last year

Hi,

I've a fact table with the tickets of a store.

 

I also have an slicer and I can filter tickets and clients by date.

 

I want a table that shows me the people who bougt the same period but in the last year too. People who didn't buy in the previous period have to be filtered.

 

How can I do this?

 

Thanks!!

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

this measure might help in what you want to achieve.
measure = 

COUNTROWS(
FILTER(
VALUES(client[clientId]),
CALCULATE(
SUM(sales[sales])
) > 0
&&
CALCULATE(
SUM(sales[sales]),
PREVIOUSMONTH('calendar'[Date])
) > 0
)
)

View solution in original post

3 REPLIES 3
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

this measure might help in what you want to achieve.
measure = 

COUNTROWS(
FILTER(
VALUES(client[clientId]),
CALCULATE(
SUM(sales[sales])
) > 0
&&
CALCULATE(
SUM(sales[sales]),
PREVIOUSMONTH('calendar'[Date])
) > 0
)
)
Anonymous
Not applicable

Hi @Mariusz, Your answer works! but now i want to know the sales of these clients who have bought in both periods. But only the sales in the las period not in the actual period!

 

Thanks a lot!!

Greg_Deckler
Super User
Super User

There is a SAMEPERIODLASTYEAR function but you will want a separate date table for that.  Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.