topic Re: Hide matrix depending on selected value in DAX Commands and Tips

Hide matrix depending on selected value

mahsy — Wed, 08 Dec 2021 08:50:21 GMT

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 contains at least one full month.
For example :
if I chose from 01/september to 29/september, following message is displayed "There is no full month in selected period"
if I chose from 01/sep to 15/oct, the table must be displayed with september data (because the month of september is complete)

Full month calculation

I would like the measure to return 1 if the selected period contains at least 1 full month

Thank you for your help 🙂

Re: Hide matrix depending on selected value

VahidDM — Wed, 08 Dec 2021 10:20:46 GMT

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/

Re: Hide matrix depending on selected value

mahsy — Wed, 08 Dec 2021 13:41:16 GMT

You solved my problem

Merci beaucoup😍