Dynamic Dateslicer with Bookmark for 2 years
Hi, I have a Date Slicer and want it to switch between 2024 and 2025. Switching to 2024 is no problem, that works fine. The problem starts with switching back to 2025... I've tried setting a filter (is 1) for the slicer for the 2025 bookmark, but it's not dynamic. Date_Filter= IF( 'MaxDatum'[LetztesDatum] >= DATE(2025,1,1) && 'MaxDatum'[LetztesDatum] <= TODAY() - 1, 1, 0 ) The idea is simply that when the date is updated, that it still shows the today-1 date on the slicer when I click the 2025 button. I don't know if this can be done diretly somehow on the slicer or rather with a DAX-Measaure? Any help is much appreciated! 🙂
Split column by delimeter in dax
Hi , I need to split the input column by demieter to display the last character before the occurance of "_" . If there is no "_" then it must display the character itself. So i just need to dispaly the last character after an "_". I need to do this in DAX as i am using Direct Query as my mode of import.Please refer the picture above for your reference. Thanks
