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.
HI,
Have Period column which have Jan to Dec if i select lets say March need to see all my values till march
dont have date column in my dataset in order to use time intelligence functions
any help highly appreciated
Solved! Go to Solution.
Add a calculated column:
MonthNumber := MONTH("1. " & table[Period])
Then use the measure:
SumOfValuesYTD =
CALCULATE(
SUM(table[Values]),
table[MonthNumber] <= SELECTEDVALUE(table[MonthNumber])
)
Add a calculated column:
MonthNumber := MONTH("1. " & table[Period])
Then use the measure:
SumOfValuesYTD =
CALCULATE(
SUM(table[Values]),
table[MonthNumber] <= SELECTEDVALUE(table[MonthNumber])
)
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |