Forum Discussion
AdministratorChange prices/values from a date
Hello everyone
I'd like to know if it's possible to tell Power BI to change data to operate from a date.
I need to analyze my sales and Power Bi does it to me by multiplying the sale price (Price Table) of a master table by the units sold of that product (sales that appear in the Sales table), the problem is that we need to change the prices from November.
Is there a way to tell you to take the new price from 01/11/22 but use the old price before that?
1 Reply
Hi Maricel ,
In order to give you a suitable solution, could you please provide some sample data in Price Table and master table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. By the way, if both of the old price(before 01/11/2022) and new price will keep in the Price table? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
