SQL Server Analysis Services database and DAX dates

AndyDD_UK — Tue, 28 Mar 2023 14:07:48 GMT

I'm using a power bi report with a date slicer showing month and a live connection to a cube, SQL Server Analysis Services database.

I'm updating the DAX via Visual Studio

I've created a calculated table in my cube but what DAX do I need so that it 'talks to' the slicer ?

eg if i select Jan 2023 and Feb 2023 months in my slicer, the calculated table only populates itself with data for Jan 2023 and Feb 2023 ?

topic SQL Server Analysis Services database and DAX dates in DAX Commands and Tips