Forum Discussion

Lena85's avatar
Lena85
Icon for Helper I rankHelper I
4 years ago

DATESMTD model does not work on generic date table

Hello,   My model has 4 tables: 1.Table with business volume over time (reporting volume_over_time) 2. Generic date table (created on the dwh level called dwh dim_calendar_dates)   3. DAX genera...
Need Help
Lena85's avatar
Lena85
Icon for Helper I rankHelper I
4 years ago

Hello

 

amitchandak thank you for your proposal, but it seems to me that the measure slicer is not compatible as it works on tables with columns containing date:

However, what I need to build is card totals that are filterable through the use of YTD/MTD/QTD etc.. like that:

When I remove date as an object in your solution, the card visual does not work. Is there any work-around it or is this solution therefore not applicable to my use case? 

 

Thanks!

Lena