Forum Discussion
Date table and then slice
Hello forum. First post. Experienced Excel user. Relatively new to PBI. I am having a table with approximately 25 000 documents. The table contains (amongst others) the following columns: -...
jsha Please try using the "Discipline" column as slicer (You can select this from the list of available visualizations)
Hello and thank you for your response. So far I have done following:
1. Built separate date table
2. Added two columns with periodic (per day) results in the date table (counta of planned issue date = date in datetable and counta of actual issue date = date in datetable)
3. Added two running totals (to count the results in step 2)
The original table and the datetable are 1:many both way related on the Planned issue date / Date.
This gives a correct total curve. But once I try to slice it on disciplines the results are completely wrong.