Forum Discussion
Creating Power BI slicer by combining 2 date/time fields from 2 different dataflows
Super UserLh_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 ...?
- Idrissshatila
Lh_8900 , yes the table view
yes check one example just to see if the data is coming right or no.
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 💡 My example:
* on 1 august Person X was on leave -> 8 hours of leave
* on 2 august, Person X was on leave for half a day & worked for half a day -> 4 hours leave + 4 hours actual hours from the timesheets
So in my table, we should have 4 hours of actual hours and 12 hours of leave. As you can also see in the screenshots of my 'table view'. The values are correct, so there must be something wrong after this step. See next picture.
Instead I get 4 hours actual hours and 132 hours leave and so this is still not correct.
When I look at the formulas of these fields, they have the same formula structure and it goes for sum in the visual itself.
Something is wrong , but what the error is, I can't see directly.Have you already faced this before?