Forum Discussion

marcopete's avatar
marcopete
Regular Visitor
10 years ago
Solved

Current time in report

Hi everyone. I'm so new in power BI. I have my third week in this tool and I could resolve so many things in BI projects, but this can't yet, I hope your help.   My reports have a certain period, ...
Need Help
Tips and Tricks
Tutorial Requests
  • itayrom's avatar
    itayrom
    10 years ago

    One expression you could try would be-

    Measure = CALCULATE(SUM([ValuesColumn]), FILTER(CalendarTable, [YearColumn] >= YEAR(NOW()) - 7))

     

     

donsvensen's avatar
donsvensen
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

Hi,

 

You can solve this by creating the measure you want to plot as "Measures last 7 years" using DAX and returning blank for periods outside your current period.

 

I have an example of this here

 

demo

 

Hope this can help you

 

/Erik

marcopete's avatar
marcopete
Regular Visitor
10 years ago

Thanks for yor answer donsvensen.

 

I made DAX measures since I begin with power BI, but retrning blank not.

 

This measure should be marked for report - level filters?

 

How I use the measure for filter time? I use dax for returning numeric results.

 

Regards.

  • donsvensen's avatar
    donsvensen
    Icon for Skilled Sharer rankSkilled Sharer
    10 years ago

    Hi

     

    You should use the new measure as the value in the charts, not as a filter

     

    So for year 2009 your dax measure should return BLANK() and then the year (as your axis) won't appear in your chart

     

    /Erik

     

     

    • marcopete's avatar
      marcopete
      Regular Visitor
      10 years ago

      Appreciate your help but cant show the period i wish.

       

      Can you show a standard example to create the measure?

       

      I create columns with current date, current year and current month.

       

      Thanks.

      • itayrom's avatar
        itayrom
        Icon for Resolver II rankResolver II
        10 years ago

        One expression you could try would be-

        Measure = CALCULATE(SUM([ValuesColumn]), FILTER(CalendarTable, [YearColumn] >= YEAR(NOW()) - 7))