Forum Discussion

mahsy's avatar
mahsy
Helper I
4 years ago
Solved

Hide matrix depending on selected value

Hi everyone, I want to put in place the following rule : if selected period contains full month, display the table otherwise display message My problem is to display the table if the period contai...
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi mahsy 

     

    Add a custom column to your table to show 1 for first and last day of each month and zero for other days and name it FLDAYS, then write a measure to sum(FLDAYS), if it's more than 2 it means a full month included and if it's less that 2 it means full month not included. If the sum is 2 then check the Day(MIN(Calendar[Date])), if it's 1 it means full month included otherwise full month not included.

     

    Share your PBIX or sample of your table in text format if you ran into any issue to apply this solution.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi mahsy 

 

Add a custom column to your table to show 1 for first and last day of each month and zero for other days and name it FLDAYS, then write a measure to sum(FLDAYS), if it's more than 2 it means a full month included and if it's less that 2 it means full month not included. If the sum is 2 then check the Day(MIN(Calendar[Date])), if it's 1 it means full month included otherwise full month not included.

 

Share your PBIX or sample of your table in text format if you ran into any issue to apply this solution.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

mahsy's avatar
mahsy
Helper I
4 years ago

You solved my problem

Merci beaucoup😍