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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |