Forum Discussion
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 by Day and Time to know how many people has been logged, I can easily filter between dates with the Date slicer, but I want to specify the hour too.
I've created another auxiliar table called 'Table' and related with my primary table 'Log'. Then I've created the following mesure:
Prueba = IF(MAX('BatchTemporales'[Hora Filter])>=MAX('Table'[Hora Filter2]);TRUE();FALSE())I want to filter the times after the selected hour ('Table'[Hora Filter2]), but it just work when both values are equal:
As you can see, I expect when HoraFilter is >= than HoraFilter2, my flag is TRUE.
Can you help me?
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 columnSo what is relationship in your pbix file, it is better you could share some sample data with model structure for us.Best Regards,
Lin
6 Replies
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 columnSo 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
Why dont you use a calculate column and not a measure
Prueba = IF('BatchTemporales'[Hora Filter]>='Table'[Hora Filter2];TRUE();FALSE())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?
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)?
