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 experts:)
we are onboarding customers to use self service orders app.
I have this Sales table and i'm trying to calculate for each customer how many orders he placed NOT from the App since he was onboarded.
customer | order date | app order |
1111 | 01/05/2023 | yes |
1111 | 22/05/2023 | no |
1111 | 03/06/2023 | yes |
1112 | 01/04/2023 | yes |
1112 | 15/04/2023 | no |
1112 | 10/06/2023 | no |
1113 | 10/07/2023 | no |
1114 | 19/05/2023 | yes |
1114 | 10/10/2023 | no |
1114 | 01/11/2023 | yes |
1114 | 19/12/2023 | no |
what i did was:
measure 1:
App start date = calculate (min(Sales[order date]) , Sales[app order]="yes")
measure 2:
now i want to count the number of orders "not from app" since app start date for each customer:
orders since app = calculate(count(Sales[order date]),Sales[app order]="no",Sales[order date]>[App start date])
i get this error for measure 2 :
which i believe refers to this part: Sales[order date]>[App start date]
how should i write this measure?
thank you
Solved! Go to Solution.
orders since app =
VAR __appstartdate = [App start date]
RETURN
CALCULATE (
COUNT ( Sales[order date] ),
Sales[app order] = "no",
Sales[order date] > __appstartdate
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
orders since app =
VAR __appstartdate = [App start date]
RETURN
CALCULATE (
COUNT ( Sales[order date] ),
Sales[app order] = "no",
Sales[order date] > __appstartdate
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 | |
101 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
102 | |
81 | |
66 |