how to select a product name in if condition dax

[ajet-p_91]

Hello everyone,

I am new to this forum.

I have a data table with columns for date, category, product, and price. I am seeking to create a DAX function to calculate the total price of a specific product for the previous year combined with the current year for one product-only current year price. My objective is to display the total price for the current year. How can I accomplish this task?

[Anonymous · Accepted solution]

Hi @ajet-p_91,

You don't need to create a DAX to fulfill your needs.

For the /Price/ column a numeric aggregation is automatically applied.

After adding the /Price/ column to the visual object, it will adaptively filter the display values based on the row and column labels.

For example, in the Matrix visualization object.

The rows labels are the /Product/ and /Date/ (year), and the value field is the /Price/.

The Price column will show the total price of each product for two years.

The next level down shows the total price of each product for last year and this year.

Another example is that you can add Product and Date fields to the slicer visual object.

You can manually choose to display the total price of which product for which year, or to display the total price for two years.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.