DAX to include current Fiscal year as well as all the current projects

[Anonymous]

Hi,

My current Power BI dashboard shows all the projects that started in the Current Fiscal Year, however, I am also trying to include all the projects that are in current status as well. For example, the project might have started in the 2021 fiscal year but is still in its Current status. Fiscal year starts at 10/1 and ends on 09/30

This is how it looks now

Project	Project Status	Progress Status	Actual Start
Project A	Current	Late	3/4/2022
Project B	Complete		1/5/2022

This is what i am trying to acheive

Project	Project Status	Progress Status	Actual Start
Project A	Current	Late	3/4/2022
Project B	Complete		1/5/2022
Project C	Current		6/20/2021

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

If you have a separate calendar table, you can filter the data by applying a measure like the one below to the table visual filter pane.

filter =
IF (
    MAX ( 'Table'[Project Status] ) = "Current"
        || MAX ( 'Table'[Actual Start] ) IN VALUES ( 'Calendar'[Date] ),
    1,
    0
)

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , if you have selected a year try like

example

new measure =
var _max = allselected(Date[Year])

var _year = summarize(filter(all(Table), Table[Status] ="Current") , Date[Year])
return
calculate( sum(Table[Value]), filter(all('Date'), ('Date'[Year] in _max || 'Date'[Year] in _year) ))