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.
How convert/ write and used two measures following below query in my porject and also shared the pbix file; https://drive.google.com/open?id=0BxreilNC4Avsc1BkZWh0bFl5Tzg
Sales Force:
Sum(
(existing [SALES LINE].[SALES LINE ID].[SALES LINE ID])
,Iif(IsEmpty([#Days]),null,1)
)
Time in Field %:
iif(IsEmpty([Measures].[#Not Field Working days])
,0
,[Measures].[#Not Field Working days]
Can anyone help on this its urgnt.
Thanks
Aamir
Hi @mdaamirkhan,
Could you be more precisely with the logic of these measures? Or you can just post some sample data and your expected result? So that we can better assist on this issue.
Regards
The below query is prepared in other report but I want to prepare this Power BI
Sales Force:
Sum(
(existing [SALES LINE].[SALES LINE ID].[SALES LINE ID])
,Iif(IsEmpty([#Days]),null,1)
)
Time in Field %:
iif(IsEmpty([Measures].[#Not Field Working days])
,0
,[Measures].[#Not Field Working days]
Result screenshot below: I wan to create this measure in Power Bi and also share my pbix file link in my previous message.
Hi @mdaamirkhan,
I am willing to help but since i do not understand your Salesforce formula, i cannot understand your requirement. PLease explain the business problem and also show the expected result.
They dont share us the businnes logic with me they said that how to use the following formula in Power BI what will be the DAX of that formula. I have also shared my pbix file in my previous replies.
Any update
Any update??
Nobody can help you because you can't describe the business logic. We can't write a formula if we don't know how it's supposed to work.
Proud to be a Super User!
How does the query work? What do those formulas do?
Proud to be a Super User!
What does any of this crap mean? These are not DAX formulas.
Proud to be a Super User!
You have to tell us how it works so we can write it in DAX. That's what we keep asking you for. Explain how you want these measures to work. What are they supposed to do?
Proud to be a Super User!
No need to help on this.
Any update
any update??
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |