topic Re: DAX help: Ignoring Date Slicer on Page and Using a Static Date in Calculation in DAX Commands and Tips

DAX help: Ignoring Date Slicer on Page and Using a Static Date in Calculation

BlueRanger — Thu, 28 Sep 2023 18:10:54 GMT

Hello,

I am running the following calculation to determine the total end employee count:

I need to modify this calculation to ignore the date slicer on my report page and instead filter on the date ending 1-24-22.

Any help would be appreciated!

Thank you

Re: DAX help: Ignoring Date Slicer on Page and Using a Static Date in Calculation

ChiragGarg2512 — Fri, 29 Sep 2023 06:46:34 GMT

BlueRanger , Use only the required date instead of the whole date column. This problem is pretty unclear as to where this date has to be placed.

To put the date in the DAX use date(22, 24, 1) instead of writing date directly.

Thank you.

Re: DAX help: Ignoring Date Slicer on Page and Using a Static Date in Calculation

BlueRanger — Fri, 29 Sep 2023 15:25:44 GMT

Thanks! I eneded up finding a solution to this problem by disconnecting my visual with this calculation from the slicer and then adding a filter to the visual with the desired date.