Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a table with vouchers and their respective prices on the one hand and a table with a list of products on the other hand. The second table is built with a column containing the voucher names. Now, the difficulty is that we apply a different logic to prices according to the date the voucher was produced (prices only apply after a specific date).
In Excel I can fix this relatively easily by doing a look up with a condition based on the time column. But in PBI, as a newbie, I don't see how to model this to obtain the column with the correct prices.
I tried to:
- merge the tables and then add a column that filters out everything before the specific date
- make a relationship based on voucher names, then applying a date filter for everything that is before the said date
- add the voucher table as a separate table, then add the filter dimension
None of this worked so far, I either get the wrong prices including former time frames or no result at all. I am sure there is an easy fix to this, but can't think of how to solve it as of now.
Would love to have some input on this.
Thanks!
Hi @Berl21
Please post a sample data that we can easily manipulate as well as your expected result. You can post a link to an excel file.
Proud to be a Super User!
Hi @danextian,
I get an error message when trying to post an excel. Hope this screenshot helps? I have simplified the issue by taking out the voucher columns and solely relying on request numbers.
I need to rebuilt column 3 of table 2 in PBI based on the request numbers and the condition "created date"> 08.10.2021. The sum should be 792 € instead of 1386€. How would you approach this?
Many thanks!
You can just post a link to an excel file in a cloud storage (Google Drive/OneDrive/Dropbox, etc.)
Proud to be a Super User!
Hi,
share the link from where i can download the PBI file.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |