Forum Discussion
If logic error in excel data model
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)
4 Replies
Greg_Deckler , Ashish_Mathur lbendlin, and danextian
can you please help me outOvaisJanzeb 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/409365Sorry, 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.
Can anyone let me know what I did wrong!!!
amitchandak can help me out, I think Min or max I don't have to use to compare value but then what you recommend.
