Issue with DAX Measure - Date

[Anonymous]

Hello, 

Basic information: 

In "Green" calculation we had the change and it means: All Product > TODAY

I have an issue with measure because the measure is counting values incorrectly. I would like the measure to also take into account the individual days of the month but for rest days of December it doesn't display values: 

How to change the calculation in this measure? 

https://uewrc-my.sharepoint.com/:u:/g/personal/170361_student_ue_wroc_pl/EZopWei7GwFHjmyczp3DqQMBtpp...

Could you help me, please? 

[mangaus1111]

Hi @Anonymous ,

what about this measure?

SWITCH(TRUE(),
diff>0&&ABS(diff)<=6,"Less than 6 months",
diff>0&&ABS(diff)>6,"More than 6 months",
"All recertified"
)

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

[Anonymous]

Hi @Anonymous ,

Please share some sample data in text format so that we could test the formula.

[Anonymous]

I attached pbix file.