Forum Discussion
Time selector
- 9 years ago
Hi Noak,
Cause you need 4 selections so I create filter table by "Enter data" option as Period table in picture
Create new Measure with swtich options based on user's selection:
Calcualted Measure - Value = if(HASONEVALUE('Filters'[Period]), SWITCH(FIRSTNONBLANK('Filters'[Period],'Filters'[Period]), "Last 24h",CALCULATE(sum(SampleData[Value]),FILTER(SampleData,SampleData[Date] >= NOW()-1 )), "Last Week",CALCULATE(sum(SampleData[Value]),FILTER(SampleData,SampleData[Date] >= NOW()-7 )), "Last Month",CALCULATE(sum(SampleData[Value]),FILTER(SampleData,SampleData[Date] >= NOW()-35 )), "Last Year",CALCULATE(sum(SampleData[Value]),FILTER(SampleData,SampleData[Date] >= NOW()-365 )), BLANK() ) )(Not sure meaning of 13 months, so i let it minus 365 days, you could modify it)
In case you want to change the scenario with YTD, MTD, today, this week, this month, this year. You could use equal express with Today() or Month(Today()), Weeknum(Today()), Year(today())
If this works for you please accept it as solution and also give KUDOS.
Could you please upload sample data and your expectation as picture? So I could quickly help you with sample file.
Thank you tringuyenminh92 , you might have saved my day.
Basicly the end client see lot of data with interval of 5 minutes:
I want the most "elegant" way to present the data for 4 possabilities:
1. last 24h
2.last week
3.last month
4.last year
P.S I noticed its not possible to drill down to minutes.