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 have some sample data below the prompt. I have to create a dax measure from this, any thoughts? Thank you!
Customer's Latest Price for specific item in the last 180 days
If latest price is less than the Retail Base Price (which is column from seperate tabe), then show the Retail Base price.
If price is blank (as having no sales history in last 180 days), then show Retail List Price.
If customer's latest price (or product of this formula) is greater than Retail List Price (column from seperate table), show Retail List Price.
Customer_No | Item_No | Unit_Price | Invoice_No | Due_Date |
C1101 | x11 | $275.00 | 6867 | 4/2/2021 |
C1099 | co22 | $250.00 | 6868 | 4/2/2021 |
C1101 | x14 | $259.00 | 6842 | 3/30/2021 |
C1099 | c200 | $189.00 | 6821 | 3/26/2021 |
Hi, @senad
The description is not very detailed.
Can you share a sample pbix and expected result here?
Best Regards,
Community Support Team _ Eason
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 |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |