Text Data

By
YearsCompleted =
VAR StartDate = 'Table'[DOJ]
VAR EndDate = DATE(2025,3,31)
RETURN
DATEDIFF(StartDate, EndDate, YEAR) -
IF (
    MONTH(EndDate) < MONTH(StartDate) ||
    (MONTH(EndDate) = MONTH(StartDate) && DAY(EndDate) < DAY(StartDate)),
    1,
    0
)

Comments

Post a Comment

Popular posts from this blog

SmartAgri - A Startup For Farmers

By
Image
  SmartAgri - A Startup For Farmers Vision To bring revolution in Indian agriculture by providing AI-powered weather forecasting and smart farming solutions to farmers, ensuring higher productivity and reduced losses. Problem Statement: Farmers lack reliable weather forecasts, leading to unpredictable crop losses. Traditional farming methods reduce soil fertility and limit crop diversity. Uncertainty in selecting the best crops, fertilizers, and pesticides reduces productivity. Lack of technological adoption in rural areas leads to financial losses and inefficient farming. Market Opportunity: Target Audience: 120 million farmers in India (60% of the population depends on agriculture). Growing Demand: Rising climate unpredictability creates demand for smart farming solutions. Government focus on agritech and subsidies to improve farming productivity. Projected Market Size: The Indian agritech market is estimated to grow to $35 billion by 2030. High adoption potential due to the nee...
Read more

Data Normalization

By
Image
Normalization is used to scale data to a specific range (often between 0 and 1 ) to improve the performance and accuracy of machine learning models and data analysis. Here are the main reasons why we use normalization: ✅ 1. To Improve Model Performance Why? Many machine learning algorithms (e.g., linear regression, neural networks) perform better when input features are on a similar scale . Example: If one feature is in the range 0-1000 (e.g., age) and another is 0-1 (e.g., probability), the model may give more importance to larger values. ✅ 2. Faster Convergence in Training Why? Gradient-based algorithms like gradient descent converge faster on normalized data because the cost function surface becomes smoother. Example: In neural networks, if inputs are not normalized, the weights can grow too large and slow down learning. ✅ 3. Preventing Bias in Models Why? Models without normalization may favor larger scales and ignore smaller-scale features, leadi...
Read more

Exploring the '1008+ Mini Apps' Application: A Gateway to Simplified Web Navigation

By
Exploring the '1008+ Mini Apps' Application: A Gateway to Simplified Web Navigation In today's digital age, the sheer number of websites and applications available can be overwhelming. Navigating between multiple platforms often requires juggling numerous tabs or installing various apps, each serving a specific purpose. Recognizing this challenge, the '1008+ Mini Apps' application emerges as a solution, offering users a consolidated platform to access a multitude of popular websites seamlessly. Overview of '1008+ Mini Apps' Developed by Bhati Capital, '1008+ Mini Apps' is designed to streamline the user experience by aggregating various renowned websites into a single interface. This approach eliminates the need for users to switch between different applications or browser tabs, providing a more efficient and organized browsing experience.  Key Features Centralized Access: The primary allure of '1008+ Mini Apps' is its ability to house numero...
Read more