Forum Discussion
Helper IDouble date slicer (date table)
Hi MIKAOKSA
I don't know what should be the correct value for your visual.
When looking into your data model, i find the [END_ACTUAL] is of datetime format, it is wrong to use this datetime column to relate the "date" table.
You need to create a "date" column from [END_ACTUAL] in date format.
You can also change the relationship among "REP_EMPOPERATWR_MV" and other tables to both, then check if it would show correct result.
Best Regards
Maggie
Community ChampionTough to say where the problem might be. Could be in a formula, could be something else. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Helper IHi,
it took me a while but here is my sample file to view if it helps figuring out what could be wrong:
https://www.dropbox.com/s/sbdxcny91o3288i/Personal%20efficiency.pbix?dl=0
BR,
Mika