Forum Discussion
Solved
Creating YTD/QTD/MTD Slicers
Hello All, I am attempting to create an easy way for users to select YTD/QTD/MTD options from a slicer. The main issue is when I pull the calculated table that stores the slicer data into Power ...
Hey v-kkf-msft,
I was able to confirm the calculated table was available in the Tabular DB. For whatever reason, I could not get Power BI to recognize this table even after running 'Process Full' on the DB - though I've never had an issue with other calculated tables.
I ended up creating the calculated table as a view in SQL and it's working perfectly now. ¯\_(ツ)_/¯
Hey v-kkf-msft,
I was able to confirm the calculated table was available in the Tabular DB. For whatever reason, I could not get Power BI to recognize this table even after running 'Process Full' on the DB - though I've never had an issue with other calculated tables.
I ended up creating the calculated table as a view in SQL and it's working perfectly now. ¯\_(ツ)_/¯