Converting 2 Calculated columns into a Slicer
I have a report that have 2 pages (Large Companies and Non Large Companies) 1 page has a calculated column that filters "Large Companies" --- Calculated column to pull up the "Large Companies" in Rows - If(ISBLANK(RELATED('Company Rollup'[Large Company Rollup])) || RELATED('Company Rollup'[Large Company Rollup])="","Other",RELATED('Company Rollup'[Large Company Rollup])) the 2nd page has a calculated column that filters "Not-Large Companies" Calculated column to pull up the "Non Large Companies" in Rows - if(ISBLANK(RELATED('Company Rollup'[Parent Market])) || RELATED('Company Rollup'[Parent Market])="",Company[Company],RELATED('Company Rollup'[Parent Market])) Filter on the page that filters out Large Companies - Not Large = if(Company[Companu Rollup ]="Other",TRUE(),FALSE()) I'm attempting to place both of the calculated columns into a slice so I will only have 1 page, then utilize a slicer with a 1. Large Companie 2. Non Large Companies 3. All Companies
Calculation based on slicer (slicer is calculable)
Hello, i need some hints for my solution. 1. What i have (and what is workling) - data calculation and a lot of slicer for detail analysis. One of the slicer is year and period (=months). Calculation is based on measurements. In Measurement is based on calculate/sum over IDs. 2. What i´m looking for: solution for calculation - "year / period" before the year in actual slicer. Well, to calculate the right year or period bevore dependign on selected slicer ist a simply thing, but to calculate new measurements (now based on period, or better to say, selected period in slicer minus 1 year)... here is my problem. i hope you have some ideas and hints for me.