Αρχείο κατηγορίας Power BI

Gross Current Graphs = var noOfMonths = -MONTH(MAX(Dates[Date])) var refDate = MAX(Dates[Date]) var preDates = DATESINPERIOD(‘Calendar Graphs'[Date];refDate;noOfMonths;MONTH) var out = CALCULATE([Gross];REMOVEFILTERS(Dates[Month & Year]);KEEPFILTERS(preDates);USERELATIONSHIP(‘Calendar Graphs'[Date];Dates[Date])) return out

Αριθμός Λογαριασμού = FORMAT ( Budget8[GL1]; “00” ) & “.” & FORMAT ( Budget8[GL2]; “00” ) & “.” & FORMAT ( Budget8[GL3]; “000” ) & “.” & FORMAT ( Budget8[GL4]; “000” ) & “.” & FORMAT ( Budget8[GL5]; “000” )

# All e-Banking Registered = VAR SelectedDate = MAX(Dates[Date]) VAR EndOfMonthDate = EOMONTH(SelectedDate; 0) RETURN CALCULATE( SUM(‘Scorecard e-Banking'[Count]); ALL(‘Scorecard e-Banking’); VALUES(‘Scorecard e-Banking'[BRANCH_ID]); ‘Scorecard e-Banking'[DateERegistered] <= EndOfMonthDate )

Δημιουργία νέου πίνακα: ALL ATMS = DISTINCT(UNION( SELECTCOLUMNS( ATMS; “ATM”;’ATMS'[Place]; “OWNED”; “Some Bank” ); SELECTCOLUMNS( ‘Euronet ATMS’; “ATM”;’Euronet Atms'[Place Fixed];”OWNED”; “Euronet”) ))

1. New Blank Query. 2. Advanced Editor let Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}) in Source

Dates = VAR CurrentDate = TODAY() RETURN ADDCOLUMNS ( CALENDAR( DATE( 1900; 1; 1); DATE( 2022; 12; 31 ) ); “Year”; YEAR([Date]); “Month in Year”; MONTH([Date]); “Month”; FORMAT([Date];”mmm”); “Quarter in Year”; QUARTER([Date]); “Quarter”; CONCATENATE(“Q”; QUARTER([Date]) ); “Month & Year Sort”; … Συνέχεια →

CALCULATE( MIN(TransactionsEBanking[Ημερομηνία]); ALLSELECTED(TransactionsEBanking[Ημερομηνία]) ) Change Date End = Var _endDate= Maxx(ALLSELECTED(‘Date'[Date Filer]),ENDOFMONTH(‘Date'[Date Filer])) Var _start_date= minx(ALLSELECTED(‘Date'[Date Filer]),’Date'[Date Filer])) return _endDate & ” ” & _start_date

Δημιουργία πίνακα on the fly για πιο εύκολο φιλτράρισμα αποτελεσμάτων. AllPresence = SELECTCOLUMNS(Presence; “name”;Presence[member_name];”presabs”;Presence[presence])

— DATEDIFF computes the delta between two dates, using different units of measure — YEAFRAC returns the delta as a fraction (in years) EVALUATE VAR StartDate = DATE ( 2011, 01, 01 ) VAR EndDate = DATE ( 2012, 12, … Συνέχεια →