- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trouble with Calculated Column with Dates
Hi, I have two tables. One with Inventory of "Units" (and their respective "Projects"), "Price Unit" and "When Date" the "Units" were sold, the other table "DatePrices" shows the dates with different prices for different dates to each of this unit. Im trying to bring the Value each "Unit" should have been priced by looking at the oldest list price {less or equal to} "When Date" it was sold. I have the following DAX in the inventory table trying to bring the Date of the list the column is bringing the value from:
//{CALCULATE( MAX(DatePrices[Date]),
FILTER(DatePrices,
DatePrices[Unit] = "1001-2" &&
DatePrices[Project] = "Praia"
&& DatePrices[Date] <= DATE(2023,3,22)
)//)} in Dax Studio and works as it should]
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I used this instead and worked, no idea why.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I used this instead and worked, no idea why.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello jpmakako,
I would be happy to try to help. Can you share a sample pbix file?
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-23-2024 08:05 AM | |||
12-04-2024 03:02 AM | |||
08-18-2024 09:59 PM | |||
02-16-2024 06:57 AM | |||
07-21-2024 05:50 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |