cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahra-in Regular Visitor
Regular Visitor

Measure for Dividing the No of Suppliers in 2016 by 2017

Hi I needa Measure for Dividing the Distinct No of Suppliers in 2016 by 2017

 

Date           Supplier

5-5-2016    ABB

5-6-2016    Siemens

7-7-2016    ABB

9-8-2016    GE

8-9-2016    ABB

1-1-2017    RTI

1-4-2017    ABB

2-3-2017    GE

6-8-2017    Siemens

7-8-2017    GE

 

In the above No of Distinct Suppliers in 2016 is 3 &

No of Distinct Suppliers in 2017 is 4.

 

Need measure to give soultion for the percentage of increase/decrease of supplier in 2017 compared with 2016

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

@mahra-in

 

Try this MEASURE. Format it as %age

 

Measure =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2017
    ),
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2016
    )
)
    - 1

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

@mahra-in

 

Try this MEASURE. Format it as %age

 

Measure =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2017
    ),
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2016
    )
)
    - 1

View solution in original post

mahra-in Regular Visitor
Regular Visitor

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

Thnak you

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 431 members 3,920 guests
Please welcome our newest community members: