Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |