Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi! 🙂
I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date]
I want to show the duplicates between the "Date selected" and ("Date selected" -30 days)
This is the table:
If i select "December 1st, 2022" it should only show these:
Thank you!
I tried using EARLIER() in a calculated column:
Repetitive_column =
IF (
COUNTROWS ( FILTER ( 'Table', 'Table'[ID] = EARLIER ( 'Table'[ID] ) ) )
> 1,
"YES",
"NO"
)
I also tried using this measure and it almost worked (adding the Repetitive_column to the filters if "YES"); It also shows non-duplicates inside the 30d range (if it is a duplicate it shows the row that's inside the 30d range and exclude the one outside):
Datefilter_measure =
CALCULATE (
COUNTROWS('Table'),
DATESINPERIOD ( 'Table'[Date], LASTDATE ( 'Table'[Date] ), -30, DAY )
)
@JayV , Try meausres like this
Have duplicate
measure =
var _cnt = calculate(count('Table'[ID]))
return
countx(Values('Table'[ID]), if(_cnt>1, [ID], Blank()))
Have No duplicate
measure =
var _cnt = calculate(count('Table'[ID]))
return
countx(Values('Table'[ID]), if(_cnt>1, [ID], Blank()))
Excuse me, where should i use this or how could i add the -30 day filter? should i add it to my existing dax?
Thanks for the help!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
11 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |