Conditional columns

[apatwal]

Hi,

I have a requirement where in I have to show the trend of Revenue and other parameters in graph and table visual.

I have below columns in my dataset

Location, Invoice_Date, CustomerName, Product, Product_description, Revenue, margin, Quantity, Cost, UnitCost, UnitPrice.

I have date range from 1st Jan 2020 to 31st Dec 2021.

Now, I need to show the trend of revenue and Margin for the year 2020 and 2021 on two different columns in table visual for Revenue (Revenue 2020 and Revenue 2021) and Margin (Margin 2020 and Margin 2021), same needs to be plot in graph.

Also, there might be cases where a customer ABC bought and item 123 on multiple dates in both years 2020 and 2021. I need there revenue in different columns.

All the revenues for all dates are in one column, there is no separate date table.

Is there any way to achieve this?

[amitchandak]

@apatwal , Put Revenue , Margain [DAte].Year or create a year column and use that viusal.

Bot able to get the challenge here

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[apatwal]

@amitchandak 

Please find the attached PBI sample file

https://drive.google.com/file/d/1eLI2gSvf84ul0RqB_8TX2QZUvgDSMtYh/view?usp=sharing

I need two different columns that shows Revenue for 2020 and 2021 separately and same for other columns.

I want below structure in PBI

There should not be any Date filter.

Thanks...

[amitchandak · Accepted solution]

@apatwal , I added measures for quantity, check those, same way you can create for revenue