Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey everyone, I am needing to find the amount of time a network is online per month. I have the total minutes each network is online per month.
how can I go about doing this?
Solved! Go to Solution.
You can use the DATEDIFF function with MINUTE as the interval to calculate the total minutes between two dates.
If you have a date dimension I would use that as the basis, and try a measure such as this:
% Time Online =
VAR __TimeOnline = [TimeOnlineMeasure]
VAR __MinDate = MIN( Dates[Date] )
VAR __MaxDate = MAX( Dates[Date] )
VAR __TotalMinutes =
DATEDIFF( __MinDate, __MaxDate, MINUTE )
RETURN
DIVIDE( __TimeOnline , __TotalMinutes )
TimeOnlineMeasure is the placeholder for the calculation that gives you the total minutes the network was online.
You can use the DATEDIFF function with MINUTE as the interval to calculate the total minutes between two dates.
If you have a date dimension I would use that as the basis, and try a measure such as this:
% Time Online =
VAR __TimeOnline = [TimeOnlineMeasure]
VAR __MinDate = MIN( Dates[Date] )
VAR __MaxDate = MAX( Dates[Date] )
VAR __TotalMinutes =
DATEDIFF( __MinDate, __MaxDate, MINUTE )
RETURN
DIVIDE( __TimeOnline , __TotalMinutes )
TimeOnlineMeasure is the placeholder for the calculation that gives you the total minutes the network was online.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |