Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated field value from max selected date

Hi Team,   I have condition to categorize the aging of Invoice if (invoice[Aging]>120,"> 120", if (invoice[Aging]>90 && invoice[Aging]<=120, "90-120", if (invoice[Aging]>60 && invoice[Aging]<...
Need Help
RondaHill's avatar
RondaHill
Regular Visitor
6 years ago

I am working on a similar issue. I created a table called Selected Dates. We are only looking back at the past 60 days.

 

SelectedDates = CALENDAR(TODAY()-60, TODAY())
 
I renamed the resulting column to be Report Date. This is the field you use in your slicers.
 
I then have a measure called SelectedReportDate.
 
SelectedReportDate = SELECTEDVALUE(SelectedDates[Report Date], TODAY())
 
This is the field you use in your other measures.
 
Hope this helps.