Forum Discussion
Solved
Slicing table output
I current have this table that I am working with. I want to write a DAX function to display the table below where the following rules is applied 1. Show name of account opened in the 2...
Hi alexumagba ,
Here are the steps you can follow：
1. Create measure.
Flag = SWITCH( TRUE(), YEAR(MAX('Table'[Year opened])) >=2022&&MAX('Table'[subscription year])=BLANK(),1, YEAR(MAX('Table'[Year opened])) >=2020&& YEAR(MAX('Table'[Year opened]))<=2022 && YEAR(MAX('Table'[subscription year]))=2022,1, YEAR(MAX('Table'[subscription year]))=2022,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks. This works perfectly well
Hi alexumagba ,
Is there a reason why you want to do this in DAX instead of using filters on the table?
Please disregard the filter. This is suppose to be a daily automated task. I want to avoid using the filter everyday