Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, can someone please help to combine these two statements.
Firs Statement:
IF(ISBLANK([Date.Actual.Start]),BLANK(),}
IF(ISBLANK([Date.Actual.Completion]),BLANK(),
(DATEDIFF([Date.Actual.Start],[Date.Actual.Completion],DAY))))
2nd Statment:
IF( NOT( ISBLANK( [Date.Actual.Start] ) ),
IF(ISBLANK([Date.Actual.Completion]),
DATEDIFF([Date.Actual.Start], [If.Today],DAY)))
Solved! Go to Solution.
Hi @mohammadyousaf ,
I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the Days.Calculations:
Days.Calculations =
VAR _tab =
ADDCOLUMNS (
'Table',
"@datediff",
IF (
ISBLANK ( [Actual Start] ),
BLANK (),
DATEDIFF (
[Actual Start],
IF ( ISBLANK ( [Actual Completion] ), TODAY () ),
DAY
) + 1
)
)
RETURN
IF (
ISFILTERED ( 'Table'[Task] ),
SUMX ( _tab, [@datediff] ),
MINX ( FILTER ( _tab, NOT ( ISBLANK ( [Actual Completion] ) ) ), [@datediff] )
)
Best Regards
@mohammadyousaf , Try like
IF(ISBLANK([Date.Actual.Start]),BLANK(),
IF(ISBLANK([Date.Actual.Completion]),DATEDIFF([Date.Actual.Start], [If.Today],DAY),
(DATEDIFF([Date.Actual.Start],[Date.Actual.Completion],DAY))))
Thank you, I tried this as well but can not get my desired out put.
I have multiple rows as below:
Task | Actual Start | Actual Completion |
A | 30-Sep-2021 | 30-Sep-2021 |
B | 6-Oct-2021 | |
So when I select A, it shows me 1 day as added +1 in the above statement
When I select B, it shows me 7 days
But when none is selected, it doesnt calculate Actual - Today. It just calculate 1 form A. What I am trying to achieve DATEDIFF from 30 Sep to Today.
@mohammadyousaf , selected value, means you are looking for a measure? or for a column
Can you share sample data and sample output in table format?
Measure.. I have chart with values A & B
so when I select A
When I select B
here when A or B not selected
it shows 1, and i want it to be MIN of Actal Start - Today() because B is still in progress and it should calculate unless there is a completion date.
Hi @mohammadyousaf ,
I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the Days.Calculations:
Days.Calculations =
VAR _tab =
ADDCOLUMNS (
'Table',
"@datediff",
IF (
ISBLANK ( [Actual Start] ),
BLANK (),
DATEDIFF (
[Actual Start],
IF ( ISBLANK ( [Actual Completion] ), TODAY () ),
DAY
) + 1
)
)
RETURN
IF (
ISFILTERED ( 'Table'[Task] ),
SUMX ( _tab, [@datediff] ),
MINX ( FILTER ( _tab, NOT ( ISBLANK ( [Actual Completion] ) ) ), [@datediff] )
)
Best Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |