Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Month Cards

Hello everyone. I have some monthly cards I made for to quickly see current situation for a use case. They work untill I use a slicer till I use date slicers/filters which is logical. So I want them ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    You can switch off interactions

    And have visual level filter on date.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey AilleryO I tried this but didn't seem to work:

 

Billable CM Last Year= CALCULATE([Billable],All(fact_harvest_time),DATESMTD(ENDOFMONTH(dateadd(fact_harvest_time[date_id],-12,,MONTH))))
 
I also tried this but this gave an error (a table of multiple values was supplied where a single value was expected)
Billable LY MTD = CALCULATE([Billable],FILTER(All(fact_harvest_time),DATESMTD(ENDOFMONTH(dateadd(fact_harvest_time[date_id],-12,,MONTH)))))
AilleryO's avatar
AilleryO
Memorable Member
6 years ago

Hi Anonymous ,

 

Is your slicer based on this table : fact_harvest_time ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yep!