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,
Solved! Go to Solution.
Hi @aggiebrown ,
Do you mean to sum up [# Cancelletions on Retention Plan],if so,you could create measures by the following formula:
Cancelled #30 Days2 = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=30),[# Cancelletions on Retention Plan])
Cancelled #61-90 Days2 = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=90&&[# Cancelled within x days]>60),[# Cancelletions on Retention Plan])
Cancelled #90+ Days = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]>90),[# Cancelletions on Retention Plan])
The final output is shown below:
if not ,Can you share the result and logic you want?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aggiebrown ,
You could create measures by the following formula:
Cancelled #30 Days2 = COUNTX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=30),[# Cancelled within x days])
Cancelled #61-90 Days2 = COUNTX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=90&&[# Cancelled within x days]>60),[# Cancelled within x days])
Cancelled #90+ Days = COUNTX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]>90),[# Cancelled within x days])
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yalanwu-msft Many thanks for that, we are almost there but it needs to calc the actual #cancellations so there is 8 Cancellations within 30 days in that example if that makes sense?
Hi @aggiebrown ,
Do you mean to sum up [# Cancelletions on Retention Plan],if so,you could create measures by the following formula:
Cancelled #30 Days2 = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=30),[# Cancelletions on Retention Plan])
Cancelled #61-90 Days2 = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]<=90&&[# Cancelled within x days]>60),[# Cancelletions on Retention Plan])
Cancelled #90+ Days = SUMX(FILTER(ALL('Acc_ID'),[# Cancelled within x days]>90),[# Cancelletions on Retention Plan])
The final output is shown below:
if not ,Can you share the result and logic you want?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That has worked - thank you!
@aggiebrown , You need to have datediff column on some common dimension say order number
average(values(Order[Order ID], datediff(min(Sales[salesdate]), max(account[cancel date]), day))
refer my blog for that: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...
Once you have this measure; create an independent bucket with start and end limit. You have to create new measures that can use this bucket.
I have explained the same here
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
@amitchandak Hey, I saw your video, but you're creating an extra table, which I don't want to do. I want to be able to achieve this with a measures instead.
If you open my sample, you will see I already have a date diff calculation that works. I just need help with bucketing based on that. The data model is not a snowflake - there is 2 data tables that need to be filtered out.
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 |
---|---|
108 | |
99 | |
82 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |