Forum Discussion
Project release every month
Hi Community, I am working to develop a report for a project releases scenarios. There are some projects that have a release date(due date on which project will be released). I need to show ...
Anonymous
pls create two measures and add each measure to the visual as a filter
Measure = if(day(today())<15, if(year(max('Table'[release date]))=year(today())&&month(max('Table'[release date]))=month(today()),1),if(year(max('Table'[release date]))=year(today())&&month(max('Table'[release date]))=month(today())+1,1))
Measure 2 = if(day(today())<15, if(year(max('Table'[release date]))=year(today())&&month(max('Table'[release date]))=month(today())+1,1),if(year(max('Table'[release date]))=year(today())&&month(max('Table'[release date]))=month(today())+2,1))
Thank you so much for your help!! I really appriciate it!!
The only problem left is with you measure ( if(day(today())<15), if I replcae 15 with the day(releasedate), I need to use the max or min function. like
if(day(today()<day(max(ReleaseDate)). Because this will evalute for each month I combined it with month and the formula now is
Measure = if(day(today()) < day(max(Sheet1[Release Date]))&& MONTH(TODAY())=month(max(Sheet1[Release Date])), if(year(max(Sheet1[Release Date]))=year(today())&&month(max(Sheet1[Release Date]))=month(today()),1),if(year(max(Sheet1[Release Date]))=year(today())&&month(max(Sheet1[Release Date]))=month(today())+1,1))
This results in
How can we not include #4 as #2 and #3 have not been released yet.
Thanks!!!