Find YTD (year to date)

[Sejal]

Area Alerts =
CALCULATE(
         COUNTROWS('user_subscription'),
                'user_subscription'[surveyno] == "" &&
                'user_subscription'[tpno] == "" &&
                'user_subscription'[fpno] == "" &&
                'user_subscription'[society] == "" &&
                'user_subscription'[buildingno] == ""
)
How to find YTD (Year to date ) in this measure ?

[SamInogic · Accepted solution]

Hi @Sejal ,

We are bit unclear with your table structure correspondence to date field, so you can refer below link for YTD calculation for your data table structure,

https://databear.com/power-bi-tips-calculate-year-to-date-values/#:~:text=Calculating%20Year%20To%20....

If possible, you can provide the Sample PBIX with your data table structure, so can help you with applying this YTD formula within your table structure.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/