Forum Discussion

Anonymous's avatar
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...
Need Help
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, Anonymous 

 

This is a video about the usage of the ISONORAFTER function. For your first formula, the usage of this function maybe a little bit wrong and only the first half of the parameters work. In addition, is there only data from 16-April-2020 to 31-December-2021 in your table?

 

Best Regards,

Caiyun Zheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-cazheng-msft ,

    No, I have data from 2019 to 2024

    • v-cazheng-msft's avatar
      v-cazheng-msft
      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's avatar
        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).