Help with Same Period Last year

[Anonymous]

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!!

[Mariusz · Accepted solution]

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]

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]

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...