Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am trying to create a measure to get results by time units every 15 minutes gap.
already tried these different measures but have not gotten the expected results. Please guide what mistake I have did.
File link: https://mega.nz/folder/uO5xnYYA#gzCcZaaiSpxOBmjtb7BCIA
Measure =
Var _MIN = CALCULATE(MIN('2022-08-17 RT_Billable GS Export'[indexStart]),USERELATIONSHIP('2022-08-17 RT_Billable GS Export'[indexStart],CombineTimeTabe15[TimeIndex]))
Var _MIX =
CALCULATE(
MIN('2022-08-17 RT_Billable GS Export'[EndIndex])
,USERELATIONSHIP('2022-08-17 RT_Billable GS Export'[EndIndex],CombineTimeTabe15[TimeIndex]))
Var _logic = IF(AND(MIN('2022-08-17 RT_Billable GS Export'[actual_start_time])>=_MIN,MIN('2022-08-17 RT_Billable GS Export'[actual_end_time])<=_MIX),1,0)
Return
_logic
Measure =
Var _MIN = CALCULATE(MIN('2022-08-17 RT_Billable GS Export'[indexStart]),USERELATIONSHIP('2022-08-17 RT_Billable GS Export'[indexStart],CombineTimeTabe15[TimeIndex]))
Var _MIX =
CALCULATE(
MIN('2022-08-17 RT_Billable GS Export'[EndIndex])
,USERELATIONSHIP('2022-08-17 RT_Billable GS Export'[EndIndex],CombineTimeTabe15[TimeIndex]))
Var _logic = IF(AND(MIN('2022-08-17 RT_Billable GS Export'[actual_start_time])<=_MIN,MIN('2022-08-17 RT_Billable GS Export'[actual_end_time])>=_MIX),1,0)
Return
_logic
=SWITCH(
FALSE(),
MIN(Raw_Data[Timestartindex]) >= [MinStartTime] && min(Raw_Data[TimeEndIndex]) <= [MaxEndTime],1)
@amitchandak can help me out, I think Min or max I don't have to use to compare value but then what you recommend.
Can anyone let me know what I did wrong!!!
@Greg_Deckler , @Ashish_Mathur @lbendlin, and @danextian
can you please help me out
@OvaisJanzeb Extremely hard to understand what to do without sample data, etc.
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |