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.
Hello,
I need to find the sales to quote ratio for the current month, sales are calculated based on ActionAttemp date column in a table and quotes are calculated based on Createdtime date column in the same table.
for finding the sales based on ActionAttempt date I wrote the following:
Solved! Go to Solution.
Hi @timazarj
You can make some changes to your Measure as the following if you don't want to create a Calendar table.
SalesActionDate =
CALCULATE (
SUM ( 'Leads'[SOLD] ),
FILTER (
'Leads'[lastAction_timestamp],
'Leads'[lastAction_timestamp]
>= ( DATE ( 2021, 3, 1 ) + TIME ( 00, 01, 01 ) )
&& 'Leads'[lastAction_timestamp]
<= ( DATE ( 2021, 3, 31 ) + TIME ( 12, 01, 01 ) )
)
)
Here is a sample.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you all for the help!
Hi @timazarj
You can make some changes to your Measure as the following if you don't want to create a Calendar table.
SalesActionDate =
CALCULATE (
SUM ( 'Leads'[SOLD] ),
FILTER (
'Leads'[lastAction_timestamp],
'Leads'[lastAction_timestamp]
>= ( DATE ( 2021, 3, 1 ) + TIME ( 00, 01, 01 ) )
&& 'Leads'[lastAction_timestamp]
<= ( DATE ( 2021, 3, 31 ) + TIME ( 12, 01, 01 ) )
)
)
Here is a sample.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @timazarj
DATESBETWEEN is a Time intelligence function therefore you need a Calendar Table in your model. Your actual Leads Table contains duplicate dates, Can't be for the use of DATESBETWEEN.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |