Forum Discussion
Aging Analysis for different day range
Hi avi081265
You can add your calculations as calculated columns and then create simple bins for them.
please refer linked tutorial:
https://www.youtube.com/watch?v=PjHgi7X3_BwIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Avian65 .
This is the steps of a simple segmentation :
1. Add a column with Dax like :Time of execution = switch (true(),[Days]>=0 && [Days]<=30 , "0-30",[Days]>=31 && [Days]<=60 , "31-60",[Days]>=61 && [Days]<=90 , "61-90",[Days]>=91 && [Days]<=120 , "91-120",[Days]>=121 ,"121+")2. Add a column for the sort order of your time execution on the visuals:
rank to sort = switch (true(),[Days]>=0 && [Days]<=30 ,1,[Days]>=31 && [Days]<=60 , 2,[Days]>=61 && [Days]<=90 , 3,[Days]>=91 && [Days]<=120 , 4,[Days]>=121 ,5)3. Modify sort order:
4. Put all you need on a matrix:
Please Note :
There were some mistakes in your data, and I did not correct them.
Just wanted to show you how it works.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello
I try to share Onedrive url, not able to share it, so I senr email to you.
I also added Sample file with some test account. in next thred.
Avian
Hello,
Thanks you very much for guidance and support.
However as I mentioned in my original thread, that I have created following measure and calculating days, which are working correctl
ToApprove = Approval Date - To be Approval Date
ToDeploy = Approval Date - To be Deploy Date
ToOffline = Approval Date - To be Offline Datewant to generate in following format. In following table I want to show the numbers of the orders for each measure in different range. Is this possible to display following matrix using 3 different measure or may be using calculated column instead of status
Avian
Hi Avian65 .
This is the steps of a simple segmentation :
1. Add a column with Dax like :Time of execution = switch (true(),[Days]>=0 && [Days]<=30 , "0-30",[Days]>=31 && [Days]<=60 , "31-60",[Days]>=61 && [Days]<=90 , "61-90",[Days]>=91 && [Days]<=120 , "91-120",[Days]>=121 ,"121+")2. Add a column for the sort order of your time execution on the visuals:
rank to sort = switch (true(),[Days]>=0 && [Days]<=30 ,1,[Days]>=31 && [Days]<=60 , 2,[Days]>=61 && [Days]<=90 , 3,[Days]>=91 && [Days]<=120 , 4,[Days]>=121 ,5)3. Modify sort order:
4. Put all you need on a matrix:
Please Note :
There were some mistakes in your data, and I did not correct them.
Just wanted to show you how it works.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi again avi081265 .
First of all, happy to help 🙂
Answering your question:
While it is possible, the process is complex and necessitates the use of virtual tables. Although in most scenarios, using measures is recommended over calculated columns. In this case, the potential benefits don't appear to justify the investment. This holds true particularly when dealing with a data source like SQL or another query, as opposed to Excel. To ensure that all calculated columns are optimized, it's advisable to perform the calculations in advance and import them into POWER BI already prepared.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you very much for help. Can you please suggest any other sample on requirement as I mentioned earlier?
Regards
Avian