topic Get % Value on a Specific Data Date. in DAX Commands and Tips

Get % Value on a Specific Data Date.

Anonymous — Mon, 13 Mar 2023 17:45:46 GMT

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

Re: Get % Value on a Specific Data Date.

BrianConnelly — Mon, 13 Mar 2023 18:44:18 GMT

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)

Re: Get % Value on a Specific Data Date.

tamerj1 — Mon, 13 Mar 2023 18:37:58 GMT

Hi Anonymous

please try

% BL Cost Curve =
Divide (

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

)