Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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.
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.
@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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
42 | |
37 | |
22 | |
22 | |
21 |