Forum Discussion
fabric_ba
2 years agoFrequent Visitor
30 days lock calculation
Hi I have two tables, 'Input' and 'Date', with the following relationships: - - An **active** relationship between ‘Date’[Date] and Input[Start date]. - An **inactive** relationship between ‘Date’...
- 2 years ago
If you want the duplicate records to be counted as one value then use a this measure formula
Measure_CountRows = Var _Cal=CALCULATE(Countrows(FILTER ( ADDCOLUMNS ( SUMMARIZE ( ( Input ), Input[Category], 'Date'[Month], 'Date'[Year], Input[Updated_on] ), "StartDateMonthNo", 'Date'[Month], "Cnt", CALCULATE ( COUNT ( Input[Category] ), USERELATIONSHIP ( 'Date'[Date], Input[Start Date] ) ) ), FORMAT ( Input[Updated_on], "MM" ) + 1 = 'Date'[Month] ))) RETURN _Cal
Else use this to create a summarized tableTable = FILTER ( ADDCOLUMNS ( SUMMARIZE ( ( Input ), Input[Category], 'Date'[Month], 'Date'[Year], Input[Updated_on] ), "StartDateMonthNo", 'Date'[Month], "Cnt", CALCULATE ( COUNT ( Input[Category] ), USERELATIONSHIP ( 'Date'[Date], Input[Start Date] ) ) ), FORMAT ( Input[Updated_on], "MM" ) + 1 = 'Date'[Month] )
SachinNandanwar
Impactful Individual
2 years agoHi fabric_ba ,
There are 3 updates for C3 in the month of Feb
But your expected output shows the count as 1.
fabric_ba
2 years agoFrequent Visitor
Yes SachinNandanwar , The numbers are based on start date. For the Feb 24 we need to look at Updated on Jan 24 in that we have only one start date for Feb 24.
- SachinNandanwar2 years ago
Impactful Individual
There are 2 duplicate entries for C1 for the update month of April.
Should they be counted as two seperate entries ? If yes then there has to be an unique identifier .- fabric_ba2 years agoFrequent Visitor
Hi SachinNandanwar
We can have mulitple entries, Updated on is the date when file/data is released.- SachinNandanwar2 years ago
Impactful Individual
There are 2 entries with the same UpdateDate and StartDate.