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

     
     
AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

 

What type is the data in fields 'Hora Filter' and 'Hora Filter2'?

Can you share your pbix file (with dummy data if necessary)? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Now I can't upload my .pbix because I have limited my job network, but I attach you two captures:

 

Hope it can help you, thanks!