Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

% change from previous time stamp

Hello All!   I am trying to calculate % change in value from a previous time stamp. To put simply, my data is organized by date, category, sub category, sub-sub category and value; hence, there are...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    Anonymous the formulas work fine as is.  The current problem is that the chart has an axis with individual dates so it presents very spikey.  It calculates a big increase on the 1st of the month because the data in fact table is all as of the first of the month and then an equally large decrease on the 2nd.

     

    Once Anonymous makes the adjustments to the visualizations I suggested they'll have a month to month representation and they'll be fine.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

So i tried doing this and things went crazier than normal. Maybe i could try remaking the Calendar table using some good dax that you may have? My date hierarchy is being difficult.

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

 

Download what I did from here ðŸ˜Š

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have requested access

    • littlemojopuppy's avatar
      littlemojopuppy
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hi Anonymous I was in a doctor's office when I saw you requested access.  Were you able to download it?