Display Week Dates

DAX DAX Calculations
1

Hello,

I am trying to display an invoice range for the previous week. For example, I have something already that shows the previous month. I use the following formula to produce this: Invoice Range = EDATE(TODAY(),-1).

I am trying to achieve the same thing but for a week.

image

I would want the above to read September 28th through October 3rd.

Any thoughts?

2

How about dateadd to go back 7 days?

DATEADD(DateTime[DateKey],-7,day)

3

Tried that just now and it won’t display the visualization. Any thoughts?

4

You’ll actually need to combine the data. As an example, to show date range on my reports, I use this measure:

Period = 
VAR StartDate = FIRSTDATE( 'Calendar'[Date] )
VAR EndDate = LASTDATE( 'Calendar'[Date] )
RETURN
    StartDate & " - " & EndDate

and this is what it looks like on a card visual:
image

1 Like
5

Heather,

That worked great. Thank you so much!

1 Like
6

glad I could help :slight_smile: