Forum Discussion

CJay11's avatar
CJay11
New Member
2 years ago
Solved

Creating a dataframe/visual table based purely on hardcoded strings and calculated measures

Hi,  I would like to create a table which is formatted as follows: "Metric"     / "Last Match"                        / "Last 5 Matches"                    / "Last 10 Matches" "Goals"      / [La...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  CJay11 ,

     

    Here are the steps you can follow：

    1. Create calculated table.

    MetricTable =
UNION(
    ROW("Metric","Goals","Last Match", [LastMatchGoalCount],"Last 5 Matches",[Last5MatchGoalCount],"Last 10 Matches",[Last10MatchGoalCount]),
    ROW("Metric","Corners","Last Match",  [LastMatchCornerCount],"Last 5 Matches",[Last5MatchCornerCount],"Last 10 Matches",[Last10MatchCornerCount]))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

lbendlin's avatar
lbendlin
Super User
2 years ago

Please use the term "measures"  by itself, to avoid mixing it up with "calculated columns"

 

if you can get your required data into a table visual then you can also send it to the dataframe in the Python or R visual.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523