Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Issue with DAX Measure - Date

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/EZopWei7GwFHjmyczp3DqQMBtppFDKN5xZogqATL-I3xvA?e=eII4Pv

 

Could you help me, please? 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I attached pbix file.

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    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.