Forum Discussion
Solved
Intersection issue with using ALL()
Hi all,
I have written this formula :
CALCULATE(
CALCULATE(
[Fish]
,LASTDATE(Black_Table[Date_Modified])
)
,ALL('0_Date_Table_Extraction')
)
in order to get the last value of Fish by the column 'Date_Modified'
Then i want to display this 'constant' on a chart but only on the date of another table 'White_Table' with the column 'Common_date'
There is a relation 1 - N between 0_Date_Table_Extraction & White_Table on date columns & between 0_Date_Table_Extraction & Black_Table
I didnt find the way to display only on the intersection between 'Date_modified' and 'Common_date'
So i have this chart. I would like only 42% after the blue column (where there is 'common_date' data)
Can you help me please ?
Then i want to display this 'constant' on a chart but only on the date of another table 'White_Table' with the column 'Common_date'
There is a relation 1 - N between 0_Date_Table_Extraction & White_Table on date columns & between 0_Date_Table_Extraction & Black_Table
I didnt find the way to display only on the intersection between 'Date_modified' and 'Common_date'
So i have this chart. I would like only 42% after the blue column (where there is 'common_date' data)
Can you help me please ?
=if([BlueBarMeasure],[ConstantFishMeasure])
2 Replies
=if([BlueBarMeasure],[ConstantFishMeasure])
Thank you ! I was looking for a hardest way to do it ...
