Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have som time series data:
that i would like to present in a table like this:
I can construct the MonthToDate measures:
and i can also calculate the ratio as maeasure.
Hi,
How have you arrived at the numbers in each of the 3 numeric columns? What is the underlying logic? Share some dataset that can be pasted in an Excel file.
HI, @Anonymous
Based on my research, you could try this way as below:
Step1:
Add a Category dim table
categories = UNION(Values(Example[Category]), ROW("Category","Ratio TS1/Ts2"))
Step2:
Create the relationship between Category dim table and basic table by Category column
Step3:
Add measre like this
Measure = IF(SELECTEDVALUE(categories[Category])="Ratio TS1/Ts2",[Ratio],CALCULATE(SUM(Example[Value])))
Then drag Category from Category dim table in to visual
Best Regards,
Lin
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |