Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Month on Month

Hi,   I need help to create Day on Day, Month on Month differnce percebtage.   I have column with count of incident number and I've removed duplicates by creating a new measure. And I have...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

    For Week, you can use the following dax:

    WOW_current =
CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=MAX('MOM'[Week])))
    WOW_Last =
IF(
    MAX('MOM'[Week]) =1 ,
    CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=
    WEEKNUM(
        DATE(YEAR(MAX('MOM'[EntryCreateDate]))-1,12,31),2))),
CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=MAX('MOM'[Week])-1)))
    WOWValue =
DIVIDE(
    [WOW_Last],[WOW_current])

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

For Week, you can use the following dax:

WOW_current =
CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=MAX('MOM'[Week])))
WOW_Last =
IF(
    MAX('MOM'[Week]) =1 ,
    CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=
    WEEKNUM(
        DATE(YEAR(MAX('MOM'[EntryCreateDate]))-1,12,31),2))),
CALCULATE(
    DISTINCTCOUNT('MOM'[IncidentID]),FILTER(ALL('MOM'),'MOM'[Week]=MAX('MOM'[Week])-1)))
WOWValue =
DIVIDE(
    [WOW_Last],[WOW_current])

 

Best Regards,

Liu Yang

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