How to create columns in a table to show Years 2017, 2018, 2019, 2020 etc

[lennox25]

Using my date table which has a 'Year' Column. How do I create a measure for 2017, 2018, 2019, 2020 etc so that they will show in columns on a table?

Category	2017	2018	2019
A	49	22	65
B	33	11	23

[tackytechtom]

Hi @lennox25 ,

You could create your measure without an explicite filter and then let Power BI do the grouping and filtering for you, i.e. in a matrix visual:

In the upper graph, the measure has the DAX as COUNT(Table[Column]).

Let me know if this works for you 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[serpiva64 · Accepted solution]

Hi,

try 

SalesAmount2017 = CALCULATE(Sales[Sales Amount], 'Date'[Year]=2017)

and so on for other years

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[lennox25]

Thankyou Worked a treat 🙂