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))

     

     

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.