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 in Others by adolpo
• 120 points
5 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
• 160 points
121 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 130 views
0 votes
1 answer
0 votes
0 answers

Can we write AES enryption in Javascript and Decryption in Java using a static SALT and IV

I'm working on AES encryption I want to ...READ MORE

Jun 4, 2019 in Others by Eighteen
• 120 points
1,194 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,970 points
413 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,970 points
327 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,970 points
187 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,970 points
1,410 views