Find Product ID Active

[ADSL]

Hello Community Team,

I have created and applied this measure to find the product ID active. With this measure, we will see the month that we stand/choose.

Product ID Active = CALCULATE(DISTINCTCOUNT('Sales Order'[Product ID]), 'Sales Order'[InvoiceType] = "F2", 'Sales Order'[Order Type] = "SALE")

Any suggestion/advise if we want to see and compare the previous month? Example: we choose the month "Aug" and compare with "Jul"

Thanks and Regards,

[Anonymous · Accepted solution]

Hi @ADSL ,

I create a table as you mentioned.

Then I create a new table.

DateTable = CALENDAR(MIN('Sales Order'[Order Date]), MAX('Sales Order'[Order Date]))

Next I create a measure and get what you want.

Measure = 
VAR _Previous =
    CALCULATE (
        DISTINCTCOUNT ( 'Sales Order'[Product ID] ),
        'Sales Order'[InvoiceType] = "F2",
        'Sales Order'[Order Type] = "SALE",
        MONTH ( 'Sales Order'[Order Date] )
            = MONTH ( TODAY () ) - 1,
        YEAR ( 'Sales Order'[Order Date] ) = YEAR ( TODAY () )
    )
VAR _Current =
    CALCULATE (
        DISTINCTCOUNT ( 'Sales Order'[Product ID] ),
        'Sales Order'[InvoiceType] = "F2",
        'Sales Order'[Order Type] = "SALE",
        MONTH ( 'Sales Order'[Order Date] ) = MONTH ( TODAY () ),
        YEAR ( 'Sales Order'[Order Date] ) = YEAR ( TODAY () )
    )
RETURN
    DIVIDE ( _Current - _Previous, _Previous, 0 )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NaveenGandhi]

Hi @ADSL 

This video should give you an idea.

https://www.youtube.com/watch?v=tu3i_BddKgc

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!