Sum Based on Slicer Date Selection

Question

Hi,&nbsp;I have matrix table i'd like to dynamically calculate measure based on date selection in slicer. I added a new column in the data table and called it "Slicer Dates'. I have a calendar Year column and Slicer Dates is added based on the values in Calendar Year column.&nbsp;Slicer have 3 options. Last Month, Last Year and Year to Date&nbsp;I have below forumula to sum values based on slicer date selection however it is giving me an error. Can anyone help with TY and LY (Last Year) calculation.&nbsp;TY = Calculate(SUM('P&amp;L'[Values]),FILTER('P&amp;L'[Slicer Dates] = ALLSELECTED('P&amp;L'[Slicer Dates)))))

amitchandak · Accepted Answer

dokat , I think You need create measures -MTD, QTD,YTD etc and use measure slicer 
&nbsp;
measure slicer https://www.youtube.com/watch?v=b9352Vxuj-Mhttps://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115https://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
&nbsp;
&nbsp;
&nbsp;
Or calculation groupshttps://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Forum Discussion

Sum Based on Slicer Date Selection

2 Replies

Related content

Sorting X- axis based on Month-Year slicer selection

slicers automatically selected based on another slicer selection

Selected slicer

Slicer default selection

Dynamic Images based on Slicer selection