Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon
I have a table called MyTSR, which has two columns. TSR and MYAILabel.
I need to create a table with the rows associated with MyTSR[TSR] and three columns with individual measures, called last 7 days, last 7 days positive, and Long Trend.
I have tried to use summarize and calculated tables, however, I think i am getting this wrong.
The table should look like
MyTSR | 7DayCount | 7DaysPositive | LongTrend |
A | text based on Last 7 days | text based on last 7 days positive | Text based on Long trend |
B | as above | as above | as above |
C | as above | as above | as above |
This is my dax code that i know i am butchering
MyTSRTable =
SUMMARIZE (
'TSRTable',
"ID", 'MyTSR'[TSR],
"7DayCount", [Last 7 Days],
"7DayPositive", [Last 7 Days Positive],
"LongTrend", [Long Trend]
)
Please can you give me some pointers as to how to do this properly?
The values are stored in a table as I have a table that I am using as a reference, and i need to do an AND calculation per row.
I hope that this helps you to help me with this.
I look forward to and will be grateful for any assistance
Lola
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try something like below.
MyTSRTable =
ADDCOLUMNS (
VALUES ( 'MyTSR'[TSR] ),
"7DayCount", [Last 7 Days],
"7DayPositive", [Last 7 Days Positive],
"LongTrend", [Long Trend]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim Thank you for this solution. It does work as required and I am grateful for your response. Have an amazing day.
Lola
Hi,
I am not sure how your datamodel looks like, but please try something like below.
MyTSRTable =
ADDCOLUMNS (
VALUES ( 'MyTSR'[TSR] ),
"7DayCount", [Last 7 Days],
"7DayPositive", [Last 7 Days Positive],
"LongTrend", [Long Trend]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |