Custom Calendar to fetch data 3 days ( hourly )/ Last 30 days ( 7 AM-7 AM ) / monthly ( Daily 7 AM )

[lakshmanvepuri]

Hi Gurus,

I am new to Power BI and exploring for the below Solution.

Please advise me how do I get the below way.

Dashboard should have three buttons.

HOURLY

DAILY

MONTHLY

https://docs.google.com/spreadsheets/d/1KAxPECarw1UbSvyjHVPZpYJkjZfxp7bX/edit?usp=share_link&ouid=10... 

Data is Enclosed.

Thanks

Lakshman

[amitchandak]

@lakshmanvepuri , You can do based on now or selected date and time

last 3 hours =
var _min = now() -time(3,0,0)
var _max = now()
return
CALCULATE([Net], FILTER('Table','Table'[Datetime] >=_min && 'Table'[Datetime] <= _max))

last 3 hours =
var _min = today() -30 + time(7,0,0)
var _max = today() + time(7,0,0)
return
CALCULATE([Net], FILTER('Table','Table'[Datetime] >_min && 'Table'[Datetime] <= _max))

same way you build for others