Forum Discussion
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...
BrianConnelly
Resolver III
Resolver IIIWhat 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)