Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I am new in DAX and i need your help !
We have the report of all the project every month and I am creating a dashboard with a data history.
With this forum, i could manage to create the project status based on tasks status but not taking in consideration the date of the report :
For example for the project 1 in date of 22022, the answer should be Finished and not In progress.
Here my DAX :
Project Status =
VAR p = SUMMARIZE(FILTER('Table','Table'[Project Name]=EARLIER([Project Name])),'Table'[Tasks status])
RETURN
IF(MAXX(p,'Table'[Tasks status])="Finished" && COUNTROWS(p)=1,"Finished","In progress")
Any help is appreciated, thank you so much!
Best regards,
Antonin
Solved! Go to Solution.
Hi @Antonin
Try this code to add a new column with DAX:
Project Status =
VAR _T =
CALCULATETABLE (
FILTER ( 'Table', 'Table'[Task Status] <> "Finished" ),
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Project Name] )
)
VAR _A =
COUNTROWS ( _T )
RETURN
IF ( ISBLANK ( _A ), "Finished", "In Progress" )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi,
Try something like this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi @Antonin
Try this code to add a new column with DAX:
Project Status =
VAR _T =
CALCULATETABLE (
FILTER ( 'Table', 'Table'[Task Status] <> "Finished" ),
ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Project Name] )
)
VAR _A =
COUNTROWS ( _T )
RETURN
IF ( ISBLANK ( _A ), "Finished", "In Progress" )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |