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,
I have a rather interesting question. What I want to do is to create a Customer Price List with Dynamics NAV data.
That means the output is a list with Items with a Customer Unit Price, based on different variables (like Line Discount or specific price). The input is a filter on customer.
So basically I want to calculate a new column, based on multiple tables with some logic statements. But how should I translate that to a DAX statement?
I tried to put the architecture of the tables and the relevant fields below. Hopefully someone can help me out.
Table Customer
Table Item
Table Sales Line Discount
Table Sales Prices
The filter is set on Customer.
The output is a list with items, with a calculated customer price.
The Field CustomerPrices is a new calculated field (new column).
The logic is:
Is it possible to move the topic to the DAX section?
It was ment to be posted there, but somehow ended up here.
Thanks a lot.
Your requirement is not quite clear, would you mind posting any sample data and expected output?
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |