Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I'm trying to calculateyearly severity starting from January. In thisexcel screenshot I have two examples that show what i'm getting vs what i'm supposed to get.
As you can see on the screenshot, I should be adding the number of paid claims from the previous months and dividing it by the amount of money paid over the same amount of months.
When I bring it to powerbi, having the month on the column makes it so the information is alwys filtered for the current month:
I already have it to filter just for the current year, but i'm not sure how to do the cumulative monthly comparison.
-- This is the code i'm using. runningTotal here refersto the cumulative YTD
I've uploaded a pbi file without sensitive information.
Also in the folder there's an Excel file i'm using as my data set. Would love all the help I can get.
https://www.dropbox.com/sh/uwitk60yfdnqc4o/AACDDIHUmihbzEiiOg1XqXsAa?dl=0
Solved! Go to Solution.
@Vega_01 , based on what I got YTD and MTD with help from date table should help
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
You can create measure using time intelligence and then divide those
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |