Forum Discussion
Insurance Earned Premium/Loss Ratio Calculation
Hi Dale,
I have been thinking about this, and I finally understood that my data model was wrong.
Now the model has the info "flat" month by month, and I let Power Bi do just aggregations.
With this model now I can see the Earned Premium month by month, and calculate the Loss Ratio change month by month.
Thank you Dale for your help!!
Gus.
hi gguadalupe
just my two cents. The datediff() Function won't return the number of days between two dates.
So what you need is the COUNT() function and a datetable. A datetable is like a calendar and includes all dates.
For further help I need a better explanation of the tables and what you exactly want to calculate and on which columns the result is based.
spuder why do you say datediff wont return the number of days? that is the point of datediff i.e the differences in the date and the interval will be specified by you
example
https://blog.crossjoin.co.uk/2015/06/22/using-datediff-to-calculate-time-intervals-in-dax/
or do i misunderstand what you are saying?
Oh I totally apologize for my mistake. I mixed it up with dateadd()
You are totally right with your explanation. Thanks for your help. So gguadalupe forgot what I said.