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 All,
Kindly help me on below query.
Result:-
Date | Site | Status | No.of days waiting |
Approved | 22 | ||
Pending from Approval | 33 | ||
Pending from Approval | 33 | ||
Pending from Approval | 33 | ||
Approved | 24 | ||
Expected Result:-
Date | Site | Status | No.of days waiting |
Approved | 0 | ||
Pending from Approval | 33 | ||
Pending from Approval | 33 | ||
Pending from Approval | 33 | ||
Approved | 0 |
already created two columns in power BI visual
1) Status = if (ISBLANK(Table1[Column1]),"Pending from Approver",
If (Table1[Column1]) = "New", "Approved"))
Note:-(Status column was displaying result like "New" and Balnk values , so written above formula )
2)
No.of_Days wating = DATEDIFF(Table1[Date],TODAY(),DAY)
Could plz help out If status is Approved, No.of days waiting level should display 0(Zero) only.
Thanks for Advance.
Solved! Go to Solution.
@Amarreddyetcs As a column:
No.of_Days wating = IF([Status] = "Approved", 0, DATEDIFF(Table1[Date],TODAY(),DAY))
@Amarreddyetcs As a column:
No.of_Days wating = IF([Status] = "Approved", 0, DATEDIFF(Table1[Date],TODAY(),DAY))
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |