Karthi Blog

  Link to the video :  https://www.youtube.com/watch?v=yRerKDM1h74

Problem In this scenario, the requirement is to create a table based on the following fields: Part Number Lemon Score Lemon Score Category Month-Year Here, both Lemon Score and Lemon Score Category are measures , not columns. Solution Since measures return scalar values and cannot be directly used for grouping or categorization in a table, we need to create a summarized table that includes the necessary dimensions and calculated measures. This can be achieved using the SUMMARIZECOLUMNS function in DAX. Here’s how you can create the summarized table: DAX SummarizeTable = SUMMARIZECOLUMNS ( 'Part Daily Details' [ Part Number ] , CalendarTable [ Month - Year ] , "Lemon Score" , [ Lemon Score ] , "Category" , [ Lemon Score Category ] ) Show more l This DAX expression creates a new table that includes: Each unique Part Number Corresponding Month-Year from the calendar table The calculated Lemon Score measure The derived Lemo...

 Based on the analysis of multi-factor investment strategies over the long term, the factor combination that yielded the highest return was Momentum and Quality . This finding is based on an analysis of 20-year SIP returns (Systematic Investment Plans), assuming a 50:50 allocation split between the two factor indices. The top performing factor combinations were: Nifty 500 Momentum 50 + Quality 50: This combination delivered the highest annualised return of 18.9 per cent . Momentum + Low Volatility: This was the second-highest performer, returning 18.7 per cent annually. Value 50 + Alpha 50: This combination followed closely, returning 18.6 per cent annually. These multi-factor strategies aim to smooth out the investment journey and improve long-term performance by combining complementary factors. It is also noted that the combination of Nifty 500 Low Volatility 50 + Nifty 500 Momentum 50 and the combination of Nifty 500 Momentum 50 + Nifty 500 Quality 50 delivered ...

 Excellent — let’s plan this like a top-tier financial planner would. 🧮 Step 1: Determine Ideal Emergency Fund Size Your monthly expense = ₹30,000 . Emergency fund is meant to cover living expenses when income stops (job loss, illness, etc.). Recommended range: Risk Level Duration Fund Amount Minimal dependents, stable job 3 months ₹90,000 Moderate dependents, average job stability 6 months ₹1,80,000 High dependents / uncertain income / self-employed 9–12 months ₹2,70,000 – ₹3,60,000 ✅ Ideal for most people: 6 months = ₹1.8 lakh. If you have dependents or irregular income, build toward ₹3 lakh . 🏦 Step 2: Where to Keep Your Emergency Fund The key principles: 100% Liquidity (instant access) Capital protection Reasonable return (better than savings a/c) We split it across 3 buckets for safety + liquidity: 1️⃣ Instant Access (30% = ₹54,000) Purpose: For true emergencies — medical, job loss, etc. Where: High-interest Savings A...

  Link to the video :  https://www.youtube.com/watch?v=hfsgVrKedJM

Step-1      Create a Remove filter button as shown below Step-2     Create a bookmark to clear filter and update the bookmark with all the data in that page. Step-3     Tag that bookmark to the created button as shown below. Step-4     Now, after the drill through is applied, you can go the page and click      on remove filters to remove the drill through filter and show all the data.

       Once Slicer is selected and Close button is clicked, Then the filter is not reflect Since we need to make some changes in the bookmark as shown below Step-1     Click on the bookmark which is pointing for Close Button. Step-2     Uncheck the data as shown below

Ref Video :   https://www.youtube.com/watch?v=cyOquvfhzNM https://www.youtube.com/watch?v=MeLaZFst02E Step-1      Create a measure like below. Cascading=     COALESCE ( DISTINCTCOUNT ( 'table' [ID] ), 0 ) Step-2      Put the created measure in this in this visual section of slicer pane as shown below Step-3     Now in the filter slicer only the relevant data related to the another selected slicer will only appear.