Forum Discussion
Need help with a dax query
Hi So below is the screenshot of Rref(Risk reference ),qref(quote reference),start date,end date and annual gross premium(which we need to calculate). What we have achieved correctly is annual gr...
Hi Taniya ,
To perform any aggregrate function using group by, you need to use CURRENTGROUP(). I do not see you using this anywhere in you formula.
Please check this article
https://www.sqlbi.com/articles/nested-grouping-using-groupby-vs-summarize/
Also, please have a look at the below video.
It is very diffcult to follow you question. Please share some sample data to help you further on this.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
is q1 and q2 are two quotes attaches to the same risk and if end date of q1 =start date of q2 then only consider that date for q2 i.e the latest quote