Calculate same day of today but last year

Used for anything related to the new Power BI Desktop and Service tools
maximax
Posts: 1
Joined: Thu Jun 06, 2019 8:46 pm

Calculate same day of today but last year

Postby maximax » Thu Jun 06, 2019 8:47 pm

Good day,



I need to calculate the number of passage of people through a gate on the same day of today but of last year.

I have the timestamp of the passage in this format 

My table (Passage) is like this:

06/06/2019 10:04:15 1
06/06/2019 10:04:18 1

I would like to know how many people passed in total last year the 6th of June

I understood I have to work with calculations but I am not able to figure out how to obtain a value in format dd/mm/yyyy that I can use to filter the main table Passage.



Thanks in advance for helping.

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: Calculate same day of today but last year

Postby PhilC » Thu Jun 06, 2019 10:38 pm



Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest