topic Re: Power Bi to show only Net Values for Current week compared to previous week. in DAX Commands and Tips

Power Bi to show only Net Values for Current week compared to previous week.

Anonymous — Fri, 02 Dec 2022 11:31:11 GMT

Hi All, Struggling to find a logic to create a measure to identify and return only values which are new compared to previous week. below is the sample data. As show in the below table measure should only return highlighted in bold italic.

Date	ID	Name	Group
21/11/2022	F046	Damian	A
21/11/2022	F047	Daniel	A
21/11/2022	F048	David	A
21/11/2022	F049	Debbie	A
21/11/2022	F050	Despina	A
21/11/2022	F051	Elke	B
21/11/2022	F052	Erikalyn	B
21/11/2022	F053	Felicity	B
21/11/2022	F054	Fiona	C
21/11/2022	F055	Gary	D
28/11/2022	F046	Damian	A
28/11/2022	F047	Daniel	A
28/11/2022	F048	David	A
28/11/2022	F049	Debbie	A
28/11/2022	F050	Despina	A
28/11/2022	F051	Elke	B
28/11/2022	F052	Erikalyn	B
28/11/2022	F053	Felicity	B
28/11/2022	F054	Fiona	C
28/11/2022	F055	Gary	D
28/11/2022	F056	James	A
28/11/2022	F054	Fiona	B
28/11/2022	F055	Gary	B

Re: Power Bi to show only Net Values for Current week compared to previous week.

ValtteriN — Fri, 02 Dec 2022 13:07:19 GMT

Hi,

Here is one way to do this:

Create the following dax:

Previous week filter = IF(ISBLANK(

CALCULATE(MAX('Table (14)'[Name]),MAX('Table (14)'[Date])-7='Table (14)'[Date],ALL('Table (14)'[Date]))),

1,0)

Place it into filter:

This will return the desired values + values which don't have value 3 weeks ago (since there is no data before this):

Now you can create maxdate filter measure or use relative date filtering:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Power Bi to show only Net Values for Current week compared to previous week.

Anonymous — Mon, 05 Dec 2022 08:28:26 GMT

Hi Anonymous ,

You can follow the steps below to get it, please find the details in the attachment.

1. Create a measure as below

Flag = VAR _selid = SELECTEDVALUE ( 'Table'[ID] ) VAR _selname = SELECTEDVALUE ( 'Table'[Name] ) VAR _selgroup = SELECTEDVALUE ( 'Table'[Group] ) VAR _maxdate = CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) ) VAR _count = CALCULATE ( COUNT ( 'Table'[ID] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[ID] = _selid && 'Table'[Name] = _selname && 'Table'[Group] = _selgroup && 'Table'[Date] < _maxdate ) ) RETURN IF ( ISBLANK ( _count ), 1, 0 )

2. Create a table visual and apply the visual-level filter with the condition(Flag is 1)

Best Regards