- Notifications
You must be signed in to change notification settings - Fork10
DAX Functions with Power BI
License
tomaztk/DAX_Functions
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
DimTime = VAR V_Calendar = CALENDARAUTO()RETURN GENERATE ( V_Calendar; VAR V_Calendar_date = [Date] VAR LetoDatum = YEAR(V_Calendar_date) VAR Kvartal = CEILING(MONTH(V_Calendar_date)/3;1) VAR MesecCifra = MONTH(V_Calendar_date) VAR DanN = DAY(V_Calendar_date) VAR KonecMeseca = EOMONTH(V_Calendar_date; 0) VAR TedenCifra = WEEKNUM(V_Calendar_date; 2) VAR DanVTednu = WEEKDAY(V_Calendar_date;2) Return ROW( "Day"; V_Calendar_date; "OnlyDay"; DanN; "Year"; LetoDatum; "Month (number)"; MesecCifra; "Quarter"; Kvartal; "Month"; FORMAT(V_Calendar_date; "mmmm"); "DayOfWeek"; DanVTednu; "NameOfWeek"; FORMAT(DanVTednu+1; "dddd"); "Year Month"; FORMAT (V_Calendar_date; "mmm yy"); "End Of Month"; FORMAT (KonecMeseca; "dd mmm yy"); "Week Number"; TedenCifra ) )DAX Examples for concatenating values of selected slicers:
Diamonds Clarity Selection = IF(ISFILTERED(diamonds[Clarity]);SELECTEDVALUE(diamonds[clarity]; "Multiple colors selected");"Filter not selected")Diamonds Color Selections =VAR Conc = CONCATENATEX(VALUES(diamonds[clarity]);[Diamonds Clarity Selection];",")RETURN(Conc)Power BI on copying mesures between datasets in same Power BI document using Power BI Template andTabular Editor.
Using Tabular Editor for copying measures
Power BI custom visual can be prepared and exported usingCharts PowerBI.Tips.
Using Custom Power BI Visual
Power BI example on using Row-level security.
Sample view of RLS in Power BI
Power BI example on getting measures as a slicer in Power BI.
View of slicer with measure names in Power BI
You can follow the steps below to clone the repository.
git clone -n https://github.com/tomaztk/DAX_Functions.gitThese samples and templates are all licensed under the MIT license.
Email questions to:tomaztsql@gmail.com
About
DAX Functions with Power BI
Topics
Resources
License
Code of conduct
Uh oh!
There was an error while loading.Please reload this page.