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
392 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

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,600 points
552 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,600 points
2,076 views
0 votes
1 answer

How do I get it to select a single row based on the value?

Try this: Sub MoveBasedOnValue2() Dim ...READ MORE

answered Jan 20, 2023 in Others by narikkadan
• 63,600 points
591 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

You can break out the "copy column ...READ MORE

answered Jan 26, 2023 in Others by narikkadan
• 63,600 points
2,369 views
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
• 170 points
426 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,770 points
1,840 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,770 points
1,581 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,770 points
1,155 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,770 points
4,929 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP