Is it possible that cards show only specific months without a filter?

[Anonymous]

Measure: Total Amount = count('Stammdaten Komplett'[ID])+0
FY 19/20 is correct and very nice but I need your advice on the 6 months and last month card. I filtert the last 6 or 1 month per month (example: only show July) but if i use the time slicer these to cards are useless of course.
Is there a way to calculated that the last month card always shows the last month without a specific filter (July, August...etc.)?

Thanks for your time! 

[Anonymous]

Hi @Anonymous,

You can consider adding a visual level filter on your cards to filter on specific data ranges or write switch functions in your dax expressions then it can return different results based on its row contents.

Add a filter to a report in Power BI 
Regards,

Xiaoxin Sheng

[Daviejoe]

Also, do you have a date table?

https://community.powerbi.com/t5/Desktop/Create-a-measure-that-shows-me-the-previous-month/td-p/6030...

[Daviejoe]

These should help you

https://docs.microsoft.com/en-us/dax/previousmonth-function-dax

https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

[Anonymous]

Thanks for the good information. I have a data table but my measure is this: 

Total Amount = COUNT('Stammdaten Komplett'[ID])

PM Count =

CALCULATE([Total Amount];PREVIOUSMONTH(Dates[Date])) is not right

Maybe the differance between count and calculate is the problem.

[Anonymous · Accepted solution]

HI @Anonymous,

Maybe you can try to use date function instead of time intelligence functions in your formula. They not required a calendar table and can be nested with other functions.

BTW, can you please share some dummy data to test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng