https://entorb.net//wiki/index.php?action=history&feed=atom&title=Power_BI
Power BI - Revision history
2026-05-06T10:25:18Z
Revision history for this page on the wiki
MediaWiki 1.43.1
https://entorb.net//wiki/index.php?title=Power_BI&diff=4887&oldid=prev
Torben at 20:40, 30 October 2024
2024-10-30T20:40:45Z
<p></p>
<p><b>New page</b></p><div>[[Category:Software]]<br />
===create date table===<br />
MyDateTable = CALENDAR(2022-07-01,TODAY())<br />
or<br />
MyDateTable = CALENDAR(MINX('myTable', 'myTable'[created (day)]),TODAY())<br />
add column of first day of week<br />
WeekStart = trunc(MyDateTable[MyDate] - WEEKDAY(MyDateTable[Date],2) + 1)<br />
Weekday = WEEKDAY(MyDateTable[Date],2)<br />
<br />
===Datetime to Time in 5min rounding===<br />
Time = mround(myTab[DateTime] - int(myTab[DateTime]) , TIME ( 0, 5, 0 ))<br />
<br />
<br />
===convert datetime column to date of monday that week===<br />
In Data View, add column using this formular<br />
MyWeekStart = trunc(MyDateTable[MyDate] - WEEKDAY(MyDateTable[MyDate],2) + 1)<br />
or<br />
my_week_sheet_closed = trunc(d_sheet_view[closure_date] - WEEKDAY(d_sheet_view[closure_date].[Date],2) + 1)<br />
<br />
<br />
===CSV/TSV parse column names from row1===<br />
= Table.PromoteHeaders(Source, [PromoteAllScalars=true])<br />
<br />
===Create a Pivot Table===<br />
report_day = SUMMARIZE(<br />
'log', <br />
'log'[date], <br />
'log'[API], <br />
"CntRequests", COUNTX(FILTER('log', 'log'[ResCode]<>0), 'log'[ResCode]) ,<br />
"CntErrors", IF(ISBLANK(COUNTX(FILTER('log', 'log'[ResCode]<>0 && 'log'[ResCode]<>200), 'log'[ResCode])),0, COUNTX(FILTER('log', 'log'[ResCode]<>0 && 'log'[ResCode]<>200), 'log'[ResCode]))<br />
)<br />
<br />
here blank in CntErrors is handled as well</div>
Torben