Forum Discussion

Diportee97's avatar
Diportee97
Helper I
1 year ago
Solved

Dax Measure issue

       Hello guys, Recently i ran into a small issue with a power bi Dashboard,the patient visits growth arrow measure isn’t showing value,it only returned percentage symbol only and...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Diportee97 ,

     

    Try adding a new column 'Year Month Number' in the calendar table and modifying the measure 'Patient visit pm'.

     

     

    Patient visit pm = 
VAR __max_year_month =MAX ( 'Calendar'[Year Month Number] )
VAR __result =
    CALCULATE (
        [Patient Visits],
        'Calendar'[Year Month Number] = __max_year_month - 1,
        REMOVEFILTERS('Calendar')
    )
RETURN
    __result

     

     

    Output:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Diportee97 ,

 

Try adding a new column 'Year Month Number' in the calendar table and modifying the measure 'Patient visit pm'.

 

 

Patient visit pm = 
VAR __max_year_month =MAX ( 'Calendar'[Year Month Number] )
VAR __result =
    CALCULATE (
        [Patient Visits],
        'Calendar'[Year Month Number] = __max_year_month - 1,
        REMOVEFILTERS('Calendar')
    )
RETURN
    __result

 

 

Output:

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum