Forum Discussion
Creating Power BI slicer by combining 2 date/time fields from 2 different dataflows
Idrissshatila I have changed the column 'Date' from Timesheets and 'DateFrom' from Leaves to data type 'Date' but it doesn't work with this solution. My table is still blank if I filter 😕
Are there other things I should watch/check?
Super UserLh_8900 , did you change them from power query (transform data ) or from the data view ?
and also you should change the data type of the date column .
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Idrissshatila Only through this did I change it
I have now changed this to 'date' in the 'transform data' view as well.
I see that the date filter works but only for timesheets and not for leave days.Example: the person who worked 40 hours last week has 132 hours of leave. So this is not really correct, any idea where it goes wrong?
- Idrissshatila
Lh_8900 ,
now you should validate the data in the data view and check the numbers there, then check the measure that is getting the numbers.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡Idrissshatila What do you exactly mean with 'data view'? Is that the table view?
Do I understand it correctly: I need to check the date values manually to see if there is a difference or ...?