Forum Discussion

Icon for Helper V rank

Helper V

9 years ago

Solved

DAX issue with date filters

I’m trying to assign a DueTimeBucket value to a list of times using the table I created above. To assign a bucket to each time I ...

DHB
9 years ago
A bit more progress. I set the max on the 23 bucket to 23:59:59.5 and now all the times are allocated. It seemed not to like the circular nature of the times and liked to have a clear start and end to the day, not the start and end being the same.

Icon for Helper V rank

Helper V

9 years ago

I've made some progress here. By changing the ACDTDueTime column to HH:mm:ss I've managed to get all the times into a DueTimeBucket except for the ones beteween 23:00:00 and 00:00:00 which are left blank.

I can't see why PBI doersn't like these particular ones.

Anonymous
Not applicable
9 years ago
Hi,

1. Can u please tell me did you create calculated column or Mesure ?
2. Do u ahve relationship with 2 Tables ?
- DHB
  Helper V
  9 years ago
  Hi Baskar,
  
  thank you for your response. it came through just as I was writing my last post. I seem to have found the sulution.
  
  DHB
  - Anonymous
    Not applicable
    9 years ago
    Nothing Problem in DAX.
    
    Note:
    The Problem is your value supply multiple columns.
    
    U ahve to check the relationship between two tables , which relationship it have .
    
    1 to 1
    or
    1 to many
    
    if 1 to many that is the problem.
DHB
Helper V
9 years ago
A bit more progress. I set the max on the 23 bucket to 23:59:59.5 and now all the times are allocated. It seemed not to like the circular nature of the times and liked to have a clear start and end to the day, not the start and end being the same.
- v-huizhn-msft
  Microsoft Employee
  9 years ago
  Hi DHB,
  
  Congadulations for you have resolve your issue. Please marks the correspoding reply as answer, so other people will find the solution clearly. Thank you for understanding and cooperation.
  
  Best Regards,
  Angelia