The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I need new ids distinct that are not avaliable in last month but dax that i made not working .
Newly WM_PFs =
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
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
thanks for reply but results are still same I think except not working . Any other way to write same DAX or any other solution ?
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.
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
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |