get unique distinct items based on a condition and a date condition

0 votes
hi could you help me

sorry my english is bad

i have a question about of how can i get a measure for use with slice visor

Any help would be greatly appreciated

i have a table with status like is showed here

maq Status Timestamp

dev1 on 10/27/2021 10:20

dev1 on 10/27/2021 9:20

dev1 on 10/27/2021 8:20

dev1 on 10/27/2021 7:20

dev1 on 10/27/2021 6:20

dev1 on 10/26/2021 21:20

dev1 off 10/26/2021 20:20

dev1 off 10/26/2021 19:20

dev1 on 10/25/2021 11:20

dev1 on 10/25/2021 10:20

dev1 on 10/25/2021 9:20

dev1 on 10/25/2021 8:20

dev1 off 10/23/2021 9:20

dev1 off 10/23/2021 5:20

dev1 on 10/22/2021 23:20

dev1 on 10/22/2021 19:20

dev1 on 10/21/2021 19:20

dev1 on 10/21/2021 14:20

dev1 on 10/20/2021 17:20

dev1 on 10/20/2021 12:20

dev1 on 10/19/2021 20:20

dev1 on 10/19/2021 18:20

dev1 on 10/18/2021 9:20

dev1 on 10/18/2021 7:20

dev2 off 10/27/2021 10:20

dev2 off 10/27/2021 9:20

dev2 off 10/27/2021 8:20

dev2 off 10/27/2021 7:20

my idea is to use a slicer visor with a measure and show me with only status off  devices depending last N day selected

for example if you select

1 days

output

dev2

dev3

dev4

if you select: 2

dev2

dev3

dev4

3 days

dev3

dev4

thanks in advance any sugestion
Nov 23, 2021 in Others by adolpo
• 120 points
21 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer
0 votes
0 answers

Write a DAX query to obtain the bottom 5 customers based on the order price

Jan 22, 2020 in Others by anonymous
• 150 points
160 views
0 votes
1 answer

How do I get the current date and time in PHP?

The time would go by your server ...READ MORE

answered Feb 16 in Others by Aditya
• 7,300 points
34 views
0 votes
1 answer

How to get current time and date in Android

In order to get the current date ...READ MORE

answered Feb 23 in Others by Aditya
• 7,300 points
316 views
0 votes
0 answers

AtoX: Take technology as a sword and forge ahead

In the eighth month of the bear ...READ MORE

Jan 22, 2019 in Others by anonymous

retagged Jan 24, 2019 by Omkar 170 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,870 points
719 views
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

answered Sep 28, 2020 in Power BI by Gitika
• 65,870 points
513 views
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
• 65,870 points
282 views
0 votes
1 answer

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

answered Nov 18, 2020 in Power BI by anonymous
• 65,870 points
2,118 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP