Solved: Re: Get the count of products with date_sold betwe...

AmiraBedh · ‎05-31-2022

I have two slicers :

month
year

I want to calculate the total of product with the date_sold between the year selected and the month selected

and the last year the same month.

Example :

Current selection :

month : january

year : 2022

the range : january 2021 - january 2022

The measure of count is simple : CountProducts = COUNT(FCT_Table[ProductID])

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

amirabedhiafi · ‎05-31-2022

YourMeasure=
CALCULATE(COUNT(FCT_Table[ProductID])
DATESINPERIOD(FCT_Table[date_sold],
LASTDATE(FCT_Table[date_sold]),-12, MONTH),
USERELATIONSHIP(dim_calendrier[id],FCT_Table[date_sold]))

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

View solution in original post

amirabedhiafi · ‎05-31-2022

YourMeasure=
CALCULATE(COUNT(FCT_Table[ProductID])
DATESINPERIOD(FCT_Table[date_sold],
LASTDATE(FCT_Table[date_sold]),-12, MONTH),
USERELATIONSHIP(dim_calendrier[id],FCT_Table[date_sold]))

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Get the count of products with date_sold between the current selection until the last year

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions

How to Get Your Question Answered Quickly