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, everyone,
I have two measures to sum the premiums as below. When I try to summarize the premium on for each month, [Premium Written] gets the premium for each month. But [YTD Premium Written] gets blank result.
Any problem with the formula? Thank you.
Dennis
[Premium Written] =
CALCULATE(SUM(Policy[Premium]))
[YTD Premium Written] =
TOTALYTD ( [Premium], DateDimension[DateKey] )
Solved! Go to Solution.
Thank you, I just figured it out.
I should choose which year in VISUALIZATION FILTER to get YTD when using TOTALYTD.
Dennis
Make sure the date in your visual is coming from your date table and not your Policy table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you, I just figured it out.
I should choose which year in VISUALIZATION FILTER to get YTD when using TOTALYTD.
Dennis
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 |