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.
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!
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |