Power BI Project
Budget: $10 – $30 CAD
i have file that have data , some of columns are : division , customer name ,parent name , some aging .
we will see customer or parent name in multiple rows in excel . i want to have total customer and parent in each division , based on this total ill create a measure that have some calculations then another measure that says if 1st measure > 0 then give me first measure otherwise 0 then ill have another data set same aging as first one but different numbers which is from same table so if performed my first measure on 1-30 days data , now same parent name but 1-30 NI data" will be in table " so based on the second measure ill perform new calculation in the another data which have NI so if measure 2 is 0 then zero otherwise ill do calculation on aging which is not due, 1-30,30-60,60-90,90-120,120-180,180-270,270-360,360+ all these given but we will perform calculations to create new measure based on them
we will see customer or parent name in multiple rows in excel . i want to have total customer and parent in each division , based on this total ill create a measure that have some calculations then another measure that says if 1st measure > 0 then give me first measure otherwise 0 then ill have another data set same aging as first one but different numbers which is from same table so if performed my first measure on 1-30 days data , now same parent name but 1-30 NI data" will be in table " so based on the second measure ill perform new calculation in the another data which have NI so if measure 2 is 0 then zero otherwise ill do calculation on aging which is not due, 1-30,30-60,60-90,90-120,120-180,180-270,270-360,360+ all these given but we will perform calculations to create new measure based on them