07 2025 档案

控制sim卡
摘要：def control_sim(enable=True): if enable: command = "netsh interface set interface name=grantSim admin=enable" subprocess.run(command, shell=True) time 阅读全文
posted @ 2025-07-27 20:26 CrossPython 阅读(11) 评论(0) 推荐(0)
选择一个月份, 自动往前推3个月显示清单
摘要：YM格式必须是 202501类似的整数, 首先根据上面的表新增一个日期表: 日期表 = VALUES('Sheet1'[ym]) 在主表里新增一个度量值, selected = VAR ym_selected = SELECTEDVALUE('日期表'[ym]) // 假设 '日期表' 是独立的日期 阅读全文
posted @ 2025-07-23 15:30 CrossPython 阅读(10) 评论(0) 推荐(0)
powerbi, 多维度排序
摘要：排1名 = VAR CurrentCategory = 'Sheet1'[大类] VAR CurrentSupplier = 'Sheet1'[供应商] VAR CurrentYearMonth = 'Sheet1'[年月] VAR CurrentAmount = 'Sheet1'[金额] RETU 阅读全文
posted @ 2025-07-22 16:03 CrossPython 阅读(17) 评论(0) 推荐(0)
PowerBI, 以日期排序后, 再以某列去重,
摘要：Table = VAR TempTable = ADDCOLUMNS( 'Sheet1', "Rank", RANKX( FILTER('Sheet1', 'Sheet1'[id] = EARLIER('Sheet1'[id])), 'Sheet1'[date], , DESC, Dense ) ) 阅读全文
posted @ 2025-07-21 16:09 CrossPython 阅读(26) 评论(0) 推荐(0)
SQL异常字符去除
摘要：import pandas as pd from grant.sql_connection import tellus_conn sql = r'''select a.uid,REGEXP_REPLACE(a.beizhu, '[\\x00-\\x1F\\x7F]', '') AS beizhu_c 阅读全文
posted @ 2025-07-21 15:21 CrossPython 阅读(10) 评论(0) 推荐(0)
powerbi, 求前12个月平均数
摘要：平均数 = VAR CurrentYearMonth = '按月汇总表'[年月] VAR CurrentYear = INT(CurrentYearMonth / 100) VAR CurrentMonth = MOD(CurrentYearMonth, 100) VAR StartYearMont 阅读全文
posted @ 2025-07-15 11:07 CrossPython 阅读(21) 评论(0) 推荐(0)
windows下 docker安装mysql,postgresql,redis,并挂载C盘
摘要：1. 拉 docker pull mysql:8 docker pull postgres:17 docker pull redis:latest 2. 装 密码 root docker run -d ` --name mysql ` -p 3306:3306 ` -e MYSQL_ROOT_PAS 阅读全文
posted @ 2025-07-12 10:10 CrossPython 阅读(42) 评论(0) 推荐(0)
powerbi分组
摘要：group name type date qty A grant male 2025/1/1 1 A edmond male 2025/1/2 2 A jush female 2025/1/3 3 B jella female 2025/1/4 4 B Hugs male 2025/1/5 5 C 阅读全文
posted @ 2025-07-09 09:21 CrossPython 阅读(19) 评论(0) 推荐(0)
ollama部署SmolVLM-256M多模态Ollama API版本
摘要：直接windows下安装部署: https://blog.csdn.net/m0_52919859/article/details/148643913 用podman部署 (docker收费) 1. 安装podman (略) 2. 拉取 Ollama 镜像 podman pull ollama/ol 阅读全文
posted @ 2025-07-05 20:36 CrossPython 阅读(209) 评论(0) 推荐(0)
powerbi, 数字 0 显示成 -, 显示成M
摘要：在格式代码框中输入：0;-0;"-" 或 #,##0;-#,##0;"-" 显示成M: 0,,.0M 显示K, #,##0, 阅读全文
posted @ 2025-07-04 16:43 CrossPython 阅读(20) 评论(0) 推荐(0)
PowerBI 去年同一天
摘要：VAR CurrentDate = TODAY() VAR LastYear = YEAR(CurrentDate) - 1 VAR CurrentMonth = MONTH(CurrentDate) VAR CurrentDay = DAY(CurrentDate) VAR IsLeapYear 阅读全文
posted @ 2025-07-01 14:42 CrossPython 阅读(24) 评论(0) 推荐(0)