Forum Discussion

Rygaard's avatar
Rygaard
Icon for Resolver I rankResolver I
3 years ago
Solved

is this month (or any other value) selected ?

I have a month slicer Now i want to return the value 1 if a month is selected and 0 if it is not selected.   ultimatly i want to use this as an easy way to format stuff   but for now i just want...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Rygaard ,

     

    Yes, two tables are necessary depending on your needs. You can hide and more according to your needs.
    (1) We can create two tables. Be careful not to build relationships.

    Calendar = CALENDAR(DATE(2023,1,1),DATE(2023,12,31))
    Month = DISTINCT('Calendar'[Date].[MonthNo])

    (2) Create a measure.

    Is selected Yes/NO = 
var _selectedvalues=VALUES('Month'[MonthNo]) 
return IF(MONTH(MAX('Calendar'[Date])) in _selectedvalues,1,0)

    (3) Then the result is as follows.

    Please refer my pbix file.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Rygaard ,

 

Yes, two tables are necessary depending on your needs. You can hide and more according to your needs.
(1) We can create two tables. Be careful not to build relationships.

Calendar = CALENDAR(DATE(2023,1,1),DATE(2023,12,31))
Month = DISTINCT('Calendar'[Date].[MonthNo])

(2) Create a measure.

Is selected Yes/NO = 
var _selectedvalues=VALUES('Month'[MonthNo]) 
return IF(MONTH(MAX('Calendar'[Date])) in _selectedvalues,1,0)

(3) Then the result is as follows.

Please refer my pbix file.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Rygaard's avatar
Rygaard
Icon for Resolver I rankResolver I
3 years ago

I will Accept this as a solution next week (have it in calender).. but hoping for some magic bullet input 😉  - since i would rather avoid the hidden Calender, not connected table version... if at all possible 🙂