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

     
     
v-lili6-msft's avatar
v-lili6-msft
Community Support
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

 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you very much! The problem was my relation between tables!