Get % Value on a Specific Data Date.

[Anonymous]

Hello Everyone

I am quite new in Power BI & got into a situation where I need help from the community...

Here is the situation;

I need to calculate the %age on the basis of the Data Date filter (I cannot use the sliding slicer due to design restrictions).

Col: Sum of BL Project Total Cost... I need its SUM in all situations only but I need Col: BL Cost Curve to change as per the selected Data Date.

For example:

If I select Data Date July 3 2020 then I'll get the value that is = 2,707,726.08/51,848,107 = 5.22%.

(BL S Curve is just a running total BL Project Cost.)

Attached is the snip for this.

Regards

Yamin

[tamerj1]

Hi @Anonymous 

please try

% BL Cost Curve =
Divide ( 

[BL Cost Curve],
CALCULATE ( [Sum of BL Project Total Cost], ALL ( 'Date' ) ) 

)

[BrianConnelly]

What is your BL Curve measure?  The Table names?

What you want to do, is create a measure using a Summarized function to summarize the BL Curve grouped by Dates.  Then filter the summarized table to the selected date or default it to the latest date.

Sample:

% of BL S Curve = 
VAR tableVariableResult = MAXX(FILTER(SUMMARIZE(ALL(<table>),<GroupByDate>,"Name Given",[BL S Curve]),<datefield>=<GroupByDate>)),"Name Given")

RETURN DIVIDE([BL S Curve],tableVariableResult)