Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |