Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |