Forum Discussion

Anonymous

Not applicable

5 years ago

Issue using isonorafter () and a Date Var

Hello guys!. Im trying to plot an accumulative sum based on the last date entered in a DateField Box. My plot has to show all the months of the current selected year (for example: if i pick 01-jun...

Anonymous

Not applicable

5 years ago

Hi v-cazheng-msft ,

No, I have data from 2019 to 2024

Community Support

5 years ago

Hi, Anonymous

Is DateFieldBox in your report a Slicer? Can you provide a sample removing sensitive data and describe your report with more details?

Best Regards

Caiyun Zheng

Anonymous
Not applicable
5 years ago
Hi v-cazheng-msft , thanks for your help.

pbi file:
https://drive.google.com/file/d/1Y47QDmcawQ7x2BQOsarrAurGbsSs7IPJ/view?usp=sharing

i want to do an accumulative sum with "programed" and "executed" dates (watch "tareas" table).
The year of my second input in DateFieldBox decides the plot range. If I select 13-06-2020 and 18-09-2020, i have to do an acumulative sum from 01-01-2020 to 31-12-2020.

Isonorafter isnt working with Var = Date() ... only works with max(date).
- v-cazheng-msft
  Community Support
  5 years ago
  Hi, Anonymous
  Do the values in this figure you want? Can you describe the calculated logic of it?
  Ive got a visual like the following figure, but the values in it different from the figure you provided.
  
  Best Regards,
  Caiyun Zheng
  - Anonymous
    Not applicable
    5 years ago
    Hello v-cazheng-msft ,
    
    My 2020 plot is ok except in the part it shows from april.
    
    The logic is that january is only january ... february is equal to january + february .... so december = december + november + october + ...... january.
    
    I think your figure is showing regardless of the year entered