Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Get % Value on a Specific Data Date.

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

2 Replies

  • BrianConnelly's avatar
    BrianConnelly
    Icon for Resolver III rankResolver III
    3 years ago

    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)

     

     

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 

    please try

    % BL Cost Curve =
    Divide ( 

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

    )