Creating/Filtering Tables using DAX Logic

DAX DAX Calculations
1

I think i’ve lost patience with dax!
Basically not sure in what way to filter to dax logic to get Year for 2015 only?
I am basically just practising getting some data from multiple different columns, filtering this, and adding a number of measures?

Is there an easier way / format I can follow to do this?
Any advice would be much appreciated.

image
image.png1059×889 18.3 KB

image
image.png1920×207 19.1 KB

2

If you just want to get year 2015 only then you want to use the FILTER function.

This is what this function is good at.

Just wrap the FILTER function around you existing one.

FILTER( ADDCOLUMN…
Year Column = 2015 )

That should do it.