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