Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering after Date hour

Hi everybody, I'm new using PowerBI, I started 2 days ago with a webbinnar but I'm having a lot of problems with one challenge: filtering between Dates with Hours.   In my report, I need to filter ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    I have tested on my side, but not reproduce the issue. and we need more detail steps for us.

    For example:
    Prueba = IF(MAX('BatchTemporales'[time])>=MAX('Table'[time2]),TRUE(),FALSE())
    So I want to know:
    What is the relationship between 'Table' and 'BatchTemporales' ?
    In my sample pbix file, my 'Table'  is a date table with date and time as below:
    and they create a relationship by date column
     
    So what is relationship in your pbix file, it is better you could share some sample data with model structure for us.
     
     

    Best Regards,

    Lin

     
     
themistoklis's avatar
themistoklis
Community Champion
7 years ago

Anonymous

 

Why dont you use a calculate column and not a measure

 

Prueba = IF('BatchTemporales'[Hora Filter]>='Table'[Hora Filter2];TRUE();FALSE())
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi themistoklis, I've tried but as [Hora Filter2] is a variable that user selects, I think I've to use a Mesure.

     

    Do you have another idea?