Comparison curent month values with old month values to get new distinct ID's

[umarshehbaz]

I need new ids distinct that are not avaliable in last month but dax that i made not working .

Newly WM_PFs =

VAR Ids = CALCULATETABLE (

VALUES ( InvDetailed_Data[WSFacID] ),

FILTER (

InvDetailed_Data,InvDetailed_Data[InvID]<>"" && NOT(ISBLANK(InvDetailed_Data[InvID])) && InvDetailed_Data[InvType]<>"" && NOT(ISBLANK(InvDetailed_Data[InvType])) && InvDetailed_Data[InvType]<>"Credit Memo" && InvDetailed_Data[InvType]<>"Debit Memo" && InvDetailed_Data[InvProgram]="WM" && InvDetailed_Data[Date Invoice] = CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) ) ))

VAR LastMonthIDs = CALCULATETABLE (

VALUES ( InvDetailed_Data[WSFacID] ),

FILTER (InvDetailed_Data, InvDetailed_Data[InvID]<>"" && NOT(ISBLANK(InvDetailed_Data[InvID])) && InvDetailed_Data[InvType]<>"" && NOT(ISBLANK(InvDetailed_Data[InvType])) && InvDetailed_Data[InvType]<>"Credit Memo" && InvDetailed_Data[InvType]<>"Debit Memo" && InvDetailed_Data[InvProgram]="WM" && InvDetailed_Data[Date Invoice]=DATEADD( 'Calendar'[Date], -1, MONTH )))

RETURN COUNTROWS(DISTINCT( EXCEPT ( Ids, LastMonthIDs ) ))

[AlB]

@umarshehbaz 

can you share the pbix? or a mock one that repros the issue, with the expected result?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@umarshehbaz 

Newly WM_PFs =
VAR Ids =
    CALCULATETABLE (
        VALUES ( InvDetailed_Data[WSFacID] ),
        FILTER (
            InvDetailed_Data,
            InvDetailed_Data[InvID] <> ""
                && NOT ( ISBLANK ( InvDetailed_Data[InvID] ) )
                    && InvDetailed_Data[InvType] <> ""
                    && NOT ( ISBLANK ( InvDetailed_Data[InvType] ) )
                        && InvDetailed_Data[InvType] <> "Credit Memo"
                        && InvDetailed_Data[InvType] <> "Debit Memo"
                        && InvDetailed_Data[InvProgram] = "WM"
        )
    )
VAR LastMonthIDs =
    CALCULATETABLE (
        VALUES ( InvDetailed_Data[WSFacID] ),
        FILTER (
            InvDetailed_Data,
            InvDetailed_Data[InvID] <> ""
                && NOT ( ISBLANK ( InvDetailed_Data[InvID] ) )
                    && InvDetailed_Data[InvType] <> ""
                    && NOT ( ISBLANK ( InvDetailed_Data[InvType] ) )
                        && InvDetailed_Data[InvType] <> "Credit Memo"
                        && InvDetailed_Data[InvType] <> "Debit Memo"
                        && InvDetailed_Data[InvProgram] = "WM"
        ),
        DATEADD ( 'Calendar'[Date], -1, MONTH )
    )
RETURN
    COUNTROWS ( DISTINCT ( EXCEPT ( Ids, LastMonthIDs ) ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[umarshehbaz]

thanks for reply but results are still same I think except not working . Any other way to write same DAX  or any other solution ?

[umarshehbaz]

@AlB 

Current month like month that we select in filter . Pervious month means 1 month previous of slected filter month.

I want to get id's that are not avaliable in previous month.

[AlB]

Hi @umarshehbaz 

You need to explain a bit more. What is last month exactly? From when to when?

What period do you want to include exactly for the first part of the EXCEPT? Is it this month? From when to when?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers