Hi all, Power BI newb here despearatly trying to get my head roudn all this. Trying to rebuild Excel sales report in PowerBI but there are a few manual calculations I'm struggling with and I'm ho...
A few screenshots below. The table is what I'd like the end result to be but the -1805 next to discount should be zero as the itemnumber begins with "DISC".
