Forum Discussion
Lena85
Helper I
Helper IDATESMTD model does not work on generic date table
Hello, My model has 4 tables: 1.Table with business volume over time (reporting volume_over_time) 2. Generic date table (created on the dwh level called dwh dim_calendar_dates) 3. DAX genera...
amitchandak
Super User
Super UserLena85 , I think you should just create table with MTD,QTD, YTD, This year etc in rows,
And then create measure using slicer value or you should use calculation group
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/