Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dax calculations

 

Hi Team...

 

I need help in creating a measure which will calculate delta difference of employee batch comparing its value to previous day. Also when i put it on a line chart visual with the date field having hierarchy of day\week\month, the new delta column should sum up to it.

Calculated column does not sum up for week or month though it shows the day week delta trend correctly.

 

Below is my example data:

 

Expected out put on line chart:

 
Need Help

3 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    How do you create your "new delta column"? What about creating a [Rank] measure insteading of using an Index column?

     

     

    Best Regards,

    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Icey,

       

      I get the delta column from the database, but it shows correct values only for day, not for month and week. Will try creating using rank measure.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Is this problem solved?

     

     

    Best Regards,

    Icey