Forum Discussion

skjellter's avatar
skjellter
Frequent Visitor
5 years ago
Solved

Get increase since yesterday

Hello everyone,   I have a dashboard that shows how many documents users have sent per month, this dashboard is refreshed every day.   Now I would like to show in the dashboard how many sent docu...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi skjellter 

     

    First check whether PrevDate returns the correct previous date. Then modify PrevValue part like below:

    VAR PrevValue = COUNTX(FILTER(ALL(sendoutsView), sendoutsView[dateAdded] = PrevDate ), sendoutsView[id])

     

    You already use COUNTX function, so don't calculate COUNT(sendoutView[id]) again in COUNTX. Let me know whether it works or not.

     

    Jing

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

this is more a data source question than a DAX question. Does your data have a "Submitted Date"  column?  Also, you may want to explain how do you define "the day before" - that is rather ambiguous if you take timezones into account.