topic Conditional columns in DAX Commands and Tips

Conditional columns

apatwal — Fri, 25 Feb 2022 06:33:18 GMT

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?

Re: Conditional columns

amitchandak — Fri, 25 Feb 2022 07:27:02 GMT

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.

Re: Conditional columns

apatwal — Fri, 25 Feb 2022 08:45:59 GMT

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...

Re: Conditional columns

amitchandak — Fri, 25 Feb 2022 09:09:31 GMT

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