Forum Discussion

DHB's avatar
DHB
Icon for Helper V rankHelper 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 ...
Need Help
  • DHB's avatar
    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.

DHB's avatar
DHB
Icon for Helper V rankHelper 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's avatar
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's avatar
    DHB
    Icon for Helper V rankHelper 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's avatar
      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.