Forum Discussion
How to sum up data based on condition
Hi Need help on below query Created below measure to get data. Below is the sample data propcode Name[Lease-SFV] chargepostmonth chargetotalamt SecondYearRent Occupied ratio ...
Hi TriveniN ,
As checked your formula, it seems involve multiple tables. Is there any relationship created among them? Could you please provide some source data in these tables 'LEASE_SFV', 'PREMINUMS_YV' and 'ReportPeriod' (exclude sensitive data) with Text format and your expected result with backend logic and special examples? By the way, is _dateM a variable? It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards