Forum Discussion
Create Pivot Table using multiple date columns of Recycling Bin
Howdy Folks ! Lets make an example of a situation : I have the Recycle bin on Windows where there are multiple date columns that represent different attributes : creation date / last modificatio...
SOLUTION
Create a separate table with all the dates used in the principal table. Create a relationship using using Power BI / Power Query / Power Pivot ( I used Power Pivot ) between each of the 3 columns and the separate date table (2 of those columns should be inactive by deselecting the checkbox at the bottom left side of the dialogue box when creating said relationship). Then create a measure using this formula "=divide(CALCULATE(COUNT(Tabla4_2[deleted]);USERELATIONSHIP(Tabla4_2[deleted];Tabla3[dates]));[Recuento de created])"
Hope it's easy to understand!
Have a nice one!