Forum Discussion
Solved
Multiple Filters with SUMX
Hi There, I hope that I have described this correctly but here it goes: I'm working on a solution to find previous year-to-date and I found that Kasper On BI had a great solution. I have a ne...
calerof
Impactful Individual
Impactful IndividualHi AdmanPowerBI ,
First and foremost, if you review the pbix file, a Calendar table was added to the model and marked as Date Table.
Then, in the Order Value measure I used an explicit measure to sum the line item price, instead of using the implicit measure LineItemPrice.
Lastly, in the Sales Same Period measure I used the Order Value measure in the RETURN calculation, instead of SUM ( Sales[sales] ).
That was pretty much it.
Best regards,
Fernando
Again thank you!