๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

 (223)
[Flask] ํŒŒ์ผ ์—…๋กœ๋“œ
[Power Query] Custom Functions let IsValidEmail = (input as text) => let name = Text.BeforeDelimiter(input,"@",{0,RelativePosition.FromEnd}), ext = Text.AfterDelimiter(input,".",{0,RelativePosition.FromEnd}), domain = Text.BetweenDelimiters(input,name&"@","."&ext), return = Text.Length(name) > 0 and Text.Length(domain) > 0 and Text.Length(ext) > 1 and Text.Length(ext) < 6 and name = Text.Select(name, {"a".."z","A".."Z","0".."..
[Power BI] ๋ฐ์ดํ„ฐ ๊ฐ€์ ธ์˜ค๊ธฐ - Postgresql ๊ธฐ๋ณธ์ ์œผ๋กœ Power BI๋Š” SSL ์ธ์ฆ์„œ๊ฐ€ ์žˆ๋Š” ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜๋งŒ ์‹ ๋ขฐํ•ด์„œ ์ธ์ฆ์„œ๋ฅผ ์–ป์œผ๋ ค๋ฉด SSL ์„ค์ •์„ ๋ณ€๊ฒฝํ•ด์•ผํ•จ postgresql.conf ํŒŒ์ผ์—์„œ ssl=off ๋กœ ๋ฐ”๊ฟ”์ค€๋‹ค ssl=off restart sudo service postgresql restart hevodata.com/learn/connect-postgresql-to-power-bi/ PostgreSQL To Power BI: 3 Best Ways To Connect - Learn | Hevo This blog outlines the three most common methods used to connect PostgreSQL to Power BI. Analyze and visualize your PostgreSQL data usin..
[Python] Flask - Failed to load module script: The server responded with a non-JavaScript MIME type of "text/plain". Strict MIME type checking is enforced for module scripts per HTML spec. ์“ฐ๋Š”๋ฐ ์˜ค๋ฅ˜ ๋ฐœ์ƒ ใ… ใ…  Failed to load module script: The server responded with a non-JavaScript MIME type of "text/plain". Strict MIME type checking is enforced for module scripts per HTML spec. import mimetypes mimetypes.add_type('application/javascript', '.mjs') stackoverflow.com/questions/56587108/flask-how-to-use-es6-modules/62236927#62236927 Flask: How to use ES6 modules? I have a working Flask app t..
[C#] list to csv using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; public class Person { public string name; public int age; public Person(string name, int age) { this.name = name; this.age = age; } }; namespace ConsoleApp1 { class Program { static void Main(string[] args) { List pList = new List(); pList.Add(new Person("J", 20)); pList.Add(new Pe..
[Power BI] DAX - SUMMARIZE SUMMARIZE Returns a summary table for the requested totals over a set of groups. Syntax SUMMARIZE (, [, ]…[, , ]…) Example SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , ProductCategory[ProductCategoryName] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount]) ) SUMM_TABLE ์ด๋ผ๋Š” ์š”์•ฝ ํ…Œ์ด๋ธ” ๋งŒ๋“ค๊ธฐ TABLE์—์„œ YEAR, PRODUCT, ST..
[Power BI] DAX - SUMMARIZECOLUMNS SUMM_TABLE ์ด๋ผ๋Š” ์š”์•ฝ ํ…Œ์ด๋ธ” ๋งŒ๋“ค๊ธฐ TABLE์—์„œ YEAR, PRODUCT, START, END ๊ทธ๋ฃนํ™”ํ•˜๊ณ  ๊ฐฏ์ˆ˜์—ด CNT๋ฅผ ์ถ”๊ฐ€ํ•œ ํ…Œ์ด๋ธ”์„ SUMMARIZECOLUMNS๋กœ ๋งŒ๋“ฌ -> SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START]) ํ•ด๋‹น ํ…Œ์ด๋ธ”์—์„œ CNT๊ฐ€ 1 ์ด์ƒ์ธ ํ–‰ ๋“ค๋งŒ ์ถ”์ถœํ•˜๊ณ  ์‹ถ์Œ SUMM_TABLE = SUMMARIZE( FILTER(SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START])), [CNT] > 1), [Year], [PRODU..
[Power BI] DAX - CALCULATE Sales ํ…Œ์ด๋ธ” ์ธก์ •๊ฐ’ : ํŒŒ๋ž€์ƒ‰์œผ๋กœ ๋œ ์ œํ’ˆ๋งŒ Sales Amount ํ•ฉ๊ณ„ ๊ณ„์‚ฐ Blue Revenue = CALCULATE( SUM(Sales[Sales Amount]), 'Product'[Color] = "Blue" ) PreC = var CurrentIndex = 'Table'[์ธ๋ฑ์Šค] var CurrentName = 'Table'[Name] return CALCULATE(SUM('Table'[C]),FILTER(ALL('Table'),'Table'[์ธ๋ฑ์Šค]= CurrentIndex - 1), 'Table'[Name] = CurrentName ) docs.microsoft.com/ko-kr/dax/calculate-function-dax CALCULATE ํ•จ์ˆ˜(DAX) - DAX ๋‹ค์Œ์— ๋Œ€ํ•ด ์ž..

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”