Karthi Blog

  If you want to catch any type of exception and resume execution, you can use a generic   except   block: try : # Code that may raise an error result = 10 / 0 # This will raise a ZeroDivisionError except Exception as e: # Handle any type of error print ( f"An error occurred: {e} " ) result = None # Code to resume execution print ( "Continuing with the next part of the code." )

  Problem :  I need to rank the rows based on serial number and the serial numbers should be ranked based on the latest inspection date. I have duplicate serial numbers in my data set. How to Achieve. Solution : you can use any of the below method to achieve without using Partition SQL Query -  Dense_Rank() over (order by InspectionDate desc, SerialNumber) as row_num

 Introduction

 MCP is used to connect any application on the internet as per our requirments. For this you can use Claud. There is another application named Goose

 You can building custom GPT Application specific to your requirements using prompts. You should include the below structure and more details instructions in order to ger more good results. Similar to GPTs we have Explore Gems in Gemini Which is free to use.

  A token roughly equals three-fourths of a word, so 100 tokens ≈ 75 words—not an exact 1:1 with words

  To create a measure in Power BI that retrieves the   confirmed_date   from   table2   based on the   ticket_num   in   table1 , you can use DAX (Data Analysis Expressions). Here is a step-by-step guide: Open Power BI Desktop  and load your data tables ( table1  and  table2 ). Create Relationships : Go to the "Model" view. Create a relationship between  table1  and  table2  using the  ticket_num  column. Create a New Measure : Go to the "Report" view. Click on the  table1  in the Fields pane. Click on "New Measure" in the ribbon. Write the DAX Formula : In the formula bar, enter the following DAX formula to create the measure: Confirmed Date Measure = CALCULATE ( MAX (table2 [confirmed_date] ), FILTER ( table2, table2 [ticket_num] = SELECTEDVALUE (table1 [ticket_num] ) ) ) This measure does the following: CALCULATE  is used to change the context in which the...

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn

Bolt--  https://bolt.new/  -For coding Cursor-- https://cursor.com/  -For coding For Building Dashboards-- https://www.thebricks.com/ Check New AI Tools launch each day --  https://openrouter.ai/ Analyze data in Excel --  https://numerous.ai/ AI tools Explore--- https://theresanaiforthat.com/ Converting Image to Text --  https://mistral.ai/news/mistral-ocr Website create--  https://lovable.dev/?via=global20&gad_source=1 Website create --  https://replit.com/ Upload your file, Start asking questions like a curious 5-year-old https://auth.julius.ai/ For LinkedIn trending topics-- https://app.socialsonic.com/ For LinkedIn posts :- https://www.supergrow.ai/ Interview prepare-- https://www.interviewmaster.ai/ Summarize webpage --  https://app.meetemily.ai/onboarding Chrome Extension- Go Full page ---> To capture the design of website Meeting transcript recorder --  https://fireflies.ai/ Video & Image Edit --  https://www.krea...

SeaBorn-- https://seaborn.pydata.org/examples/index.html Plotly -- https://plotly.com/python/ D3--  https://d3js.org/

Below [RCTQTY] is a column & [Sa mpling Measure] is a measure Expected Uploads Measure1 = S UMX (     Re ceipts_SAP,     Rec eipts_SAP[RC TQTY] * [Sa mpling Measure] ) Below [ SN_Count] is a column & [ Expected Uploads Measure1] is a measure Upload Percentage = D IVIDE ( S UM ( R eceipts_LSQD[ SN_Count]) , [ Expected Uploads Measure1])