Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Graph missing Data

Hi PBI Community,   I am trying to graph a cumulative total (# of expirations) by a week ending date.  It appears to be working (mostly) with the exception that if a particular week ending date did...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Hi  again codestule

     

    Please dont take offence to the "not doing your job" comment.

    I copy and paste it it on all my posts because I am an uppaid volunteer who is happy to share skills to people who are keen to learm but some members just want their jobs doing for free. 😀😀😀

     

    Sorry to hear you are still struggling with your cummulative report.

     

    The solution I provided works

    Click here to download and try it 

     

    I have also provide a screen print to show it works.

    In the top monthly blue graph you can see there were no sales in some weeks.

    But the top red line and the bottome blue graph show the cummulative values.

    So I trust you agree that this solution does work, but you may have copied it incorrectly?

     

    Try download the example again and carefully change it to your data, but do not change the logic.

     

    If you still have problems then copy and paste your data into the chat as a text table (not a screen shot) so we can import the data and share the solution.  Remember not to share any private date

     

    Good luck!

     

    I am sure you will master how to produce cumulative reports soon, it it difficult the first time.  😎

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

speedramps ,

 

I give you kudos for your time/effort and very much appreciate it.  Contrary to what was said in your post, I'm not looking for (nor do I expect) someone to give me the solution.  I've attempted to adapt your proposal and I get the same results I already have, it calculates the cumulative total just fine except if a given weekending doesn't have any data it still displays 0 on the graph (this is both with the use of a separate date table and w/o).

Again, thank you for your time and effort and I do sincerely appreciate it however at this time I'm still not able to accomplish what I'm seeking out to do with your proposal.

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    Hi  again codestule

     

    Please dont take offence to the "not doing your job" comment.

    I copy and paste it it on all my posts because I am an uppaid volunteer who is happy to share skills to people who are keen to learm but some members just want their jobs doing for free. 😀😀😀

     

    Sorry to hear you are still struggling with your cummulative report.

     

    The solution I provided works

    Click here to download and try it 

     

    I have also provide a screen print to show it works.

    In the top monthly blue graph you can see there were no sales in some weeks.

    But the top red line and the bottome blue graph show the cummulative values.

    So I trust you agree that this solution does work, but you may have copied it incorrectly?

     

    Try download the example again and carefully change it to your data, but do not change the logic.

     

    If you still have problems then copy and paste your data into the chat as a text table (not a screen shot) so we can import the data and share the solution.  Remember not to share any private date

     

    Good luck!

     

    I am sure you will master how to produce cumulative reports soon, it it difficult the first time.  😎

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      speedramps ,

       

      My apologies for how I interpreted your original response, thanks for getting back to me again.  Unfortunately I am unable to download the file you shared, I attempted to use both my work and personal one drive account and in both cases it says there was an "error" and failed to download.  I have updated my dax as follows:

       

      zTESTcumExpSt =
      VAR myMinDate = MIN('date_calendar (2)'[WeekEnding])
      VAR myMaxDate = MAX('date_calendar (2)'[WeekEnding])
      VAR tDate = TODAY()
      VAR selectedStation = SELECTEDVALUE('met_mac (2)'[STATION])

      RETURN
      IF(myMinDate > tDate, BLANK(),

      CALCULATE('met_mac (2)'[zE1Tot],
      FILTER(ALL('met_mac (2)'),
      'met_mac (2)'[STATION] = selectedStation),
       
      FILTER(ALL('met_mac (2)'),
      'met_mac (2)'[weekEndingOriginalExpire] <= MAX('date_calendar (2)'[WeekEnding])),

      FILTER(ALL('met_mac (2)'),
      OR('met_mac (2)'[INSPECTED] > MAX('met_mac (2)'[weekEndingOriginalExpire]), 'met_mac (2)'[INSPECTED] = BLANK())),


      'date_calendar (2)'[WeekEnding] <= myMaxDate
      ))
       
      Upon doing this my graph still appears to not show the cumulative for certain week ending criteria even when using a separate date table as you have suggested:

       

      None the less, I don't doubt your proposed solution works.  I feel like it has to be something in the filtering/slicing on my end but it is driving me crazy trying to figure it out.

      • speedramps's avatar
        speedramps
        Icon for Super User rankSuper User
        4 years ago

        Hi agian codestule

         

        No appology necessary, but thank you and thanks for the kudos.

        Well done on developing a solution. 😀

        I have refeshed the link, so you can try download my example again.

        It is on Onedrive, so you shoud be able to access it

        https://1drv.ms/u/s!AgMTUY3Uvq3bg6lXcgsLMa0rZtCRGA?e=0O3Rov

         

        Good luck!

         

        If you need more help then raise a new tickey and quote speedramps anywhere in the text and I will receive an automated notification, but another super use might get to you first. 😎