Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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
    3 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.  😎

     

     

speedramps's avatar
speedramps
Super User
3 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
3 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
    Super User
    3 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. 😎