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.
Hey Team,
The Following is my data, and what i want to achieve, I have tried to extract max date time within each date, and got the status message but cannot do, i tried to extarct to a Createtable, no use
Solved! Go to Solution.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Don't forget that the solution is presented as a calculated column. Therefore you can easily add a measure that does this computation. (If it had been implemented as a measure it would have been much (much) more complex.)
Yield = divide(sumx(Filter('Table','Table'[status_name] in {"Done","Queue"}),'Table'[Ct]),sumx(filter('Table','Table'[status_name]="Inbox"),'Table'[Ct]))
see attached.
Hi,
You may download my PBI file from here.
Hope this helps.
My apologies for a tardy Way, I am New on this,
File: https://drive.google.com/file/d/1mUAKU8dQs0LLyseb-RvgkO21zXguFlMX/view?usp=sharing
output: would be as of Date takein in to all teh task as of date:
Output I need is:
I will give Try to Explain:
As of Date : 28/03/2022:
For all the Tasks that are there until 28/03,
see the last Modified Status
Account it Under the Appraisal
Ex:
There Might be a task that has been pending on day-1 and was completed Day-7
we will acount it as pending count for all eh the day until day6
but on on day 7 onwards it will account under Completed
Please let me know if this is fine
Your tasks change status multiple times a day. Please describe how this should be handled. Should the last status for each day be used?
for example
The last modified status on that day is used for that day. yes it chnages in a day, but we take into account the last modified on the day
Just a Added Question , could we do calculate step on Countrows ex:
Done/Inbox etc?, becasue currently i am extrating this and doing it and it works but wanted to see
Your question is unclear. Please show the expected outcome based on your sample data.
IN the Above Data, I am calculating a Seperate Column along side the status , = Queue/Inbox, on day to day basis
Inbox | Done | Queue | Yeild% | |
Date | 5 | 1 | 3 | (3+1)/5 |
Don't forget that the solution is presented as a calculated column. Therefore you can easily add a measure that does this computation. (If it had been implemented as a measure it would have been much (much) more complex.)
Yield = divide(sumx(Filter('Table','Table'[status_name] in {"Done","Queue"}),'Table'[Ct]),sumx(filter('Table','Table'[status_name]="Inbox"),'Table'[Ct]))
see attached.
Great Reply I understood my Mistake i earlier used Measure,
This is teh first outcome
thanks
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |