‫‪Dynamic Format for Measures‬‬

‫ا ﻦ راﻫﻨﻤﺎ ﺑﺨﺸﯽ از ﻣﻄﺎﻟﺐ ﻣﺮﺑﻮط ﺑﻪ راﻫﻨﻤﺎی زﺑﺎن ‪ DAX‬اﺳﺖ ﮐﻪ در ﮐﺎﻧﺎل ﻠﮕﺮا ﯽ ‪ [Link]/Power_of_BI‬ﻣﻨﺘﺸﺮ‬

‫ﯽﺷﻮد‪ .‬ﺑﺮای دﺳﺘﺮﺳﯽ ﺑﻪ ﺳﺎ ﺮ ﻣﻄﺎﻟﺐ ﻣﺮﺑﻮط ﺑﻪ زﺑﺎن ‪ ،DAX‬زﺑﺎن ‪ ،M‬ﭘﺎور ﮐﻮﺋﺮی‪ ،‬اﺻﻮل ﻃﺮاﺣﯽ داﺷﺒﻮردﻫﺎ و‬

‫ﭼﺎﻟﺶﻫﺎی دﻧﯿﺎی واﻗﻌﯽ ﺑﻪ ا ﻦ ﮐﺎﻧﺎل ﻠﮕﺮا ﯽ ﺑ‪BC‬ﻮﻧﺪﯾﺪ‪.‬‬

‫–‬
 ( %&$ ' - !" # $ – -
* +

' + 7& 8 , *9$ 6& " 8 $ * " 4 & ! 56 * * $ ," -. & / ,"0 12 $ ", 3

0 > $6 $ * = 0 >0 ? 8 &!; % @# ; *; AB C DE : 9 6 , * :5 ; <

&> PBI HL 3 4 M N H: 5 / < . $ : 9 C K , $ < $ I$ 6& " 8 F GH 0

P & $*( " &5 H ( 63 O- B8 DAX 6 , $ ? , K" 9; . " ;*- 56 * 9

., 5 6 * S& C3 &5 R/ B 7& & * 9 $ 4 . 5 " Q $4 * "

0 0 > $6& " R/ B

* * & 6 9$ . H $ &- B " & 8 H6 , , 5 0 >8 $6& " R/ B & * 5*3 M * :T 4

& * &; *H 6&! * Column Tools 6 & >* ,8 8 (Data Pane) 6& " 8 L

. WT 6& " 6 C & # : 9 R/ B Fromatting 7& Data Structure

1 &A

F(General) &9 R/ B Q R * 4I5* Y , * ZT 1 &A ; : 9 $R/ B , 3 & : 9 DX

9 9 (Percentage) R/ B F(Whole Number) [ # R/ B F(Decimal Number) R/ B F(Currency) / R/ B

. P$ (Scientific)

1
 ( %&$ ' - !" # $ – -

2 &A

: 9 1B X < ; > 1B *" $ 6 * &; K" : 9 N H:5 &9 / < General * ZT

/&5 < ZT Currency * . ] C 9 ^ 4 6& " 2H 4 9$ 4 I 5 ;* ! $ * !/ * &;

_X ) ZT * "*H B " 2H 4 9$ 4 I 5 * $ & " $ N H: 5 /&5 < * &; : 9

. [# : 9 ; . * &` 9$ Whole Number Decimal Number $* .(6 0 < IRR

c - : 9 2> . K " Percent * , B6 % D =b" ;Z 100 ^ & P$ _

. I9 ZT * 4 - 9 9 R/ B 8M& -

. B K" & $6 6& " 4 * &; K" I $0 ? F &; Z T @"& * " 2H &>& $R/ B , 8 $

* . B :5* K"C K $ 0 > 0 ? , 6& " 8 7& $ R/ B , C K !/ B , ; * ; AB

d 4 , K " . $ O A - C K R/ B 8 0 > , `" $ * E ;d & R & * " Dax 6 , , Format d , K"0

* ; $ &- ; $ *( " &5 R/ B L _< 6 , =5 ; $ &- ; _< 4 * . &; _ ! 4 * $ &; e

. ; $ &T $ f

Format d R/ B

_ B $ P$ _P ; K" R/ B g * * !; * ) ; *; ; K" R/ B g &# _ I ; Hd , K"

H R` 4 6 5 ; H 8 /, 6 C I> * > $ , K" 9 $ .( " # : 9 & /g K"

, $ < * &> K T $W- ; 0 > 4 . 3 &A ; 6 0 >* C I >* 4- 5, :5.

1 M P + 4 4 C K + ^,6 D . K " $6 *9$ 6 P3 R/ B , 6 & &; e 7& & 4 K

0 ? WT 6& SelectedValue d , K " . ; $ &- $W- ; , - : 9 0D - e i R/ B g "

*#K ; : 9 Dax & " . g : 9 R/ B F `" * S& W- ; RP< &; : 9 W- ; L > `"

. 2 * *K j 4

2
 ( %&$ ' - !" # $ – -

3 &A

RealValue =
VAR R_Value = SUMX(KPI_List,[ B ])
RETURN
SWITCH( SELECTEDVALUE(KPI_List[W- ;]),
"PCC", FORMAT(R_Value, "#,# KWh"),
"OEE", FORMAT(R_Value, "#.#%"),
"ASR", FORMAT(R_Value, "#.#%"),
"AFR", FORMAT(R_Value, "#,#.00"),
"R_Return",FORMAT(R_Value, "#,#,,.0 M IRR"),
"D_Return",FORMAT(R_Value, "#,#,.0 K $"),
FORMAT(R_Value, "#,#.#")
)
lH& 9; 6& . " $ _ B4 9; &A R/ B 4 *( . " ; K" Q $ + 6& " R/ B g % 4 9$ ,

. _ ! * $6 7& g C K ; K" $R/ B 6& " 8 $ ;

4 &A

C &# , -. $ 0 > , 6& " 8 R/ B g $& / 6 3 C & * " 4 Dax & " -"6 " 8

" -. : 9 & / 0 > , 6& " 4 - . " ; K" 4 , , * &9 _ H . K" Hg 6& " 4

. &; 9 & " % &# 6 ; " e @ ; *9$ /% 4 K " R/ B g 6& " 4 , 9 + P 6 &

3
 ( %&$ ' - !" # $ – -

5 &A

P g T $S ; " * , C& `" 6 9$ FormatString 0& " C & # ' " `" $ R/ B " H 3 4

. ; $ &- * ;& " P &"

RealValue =
VAR R_Value = SUMX(KPI_List,[ B ])
RETURN
FORMAT(R_Value, SELECTEDVALUE(KPI_List[FormatString]))

? &5 R/ B , K"

, * 6 0X 4 7&9( *!" # < K " (Explicit Measure) [ *( " , 9 < &5 R/ B , K"

: " ; K" ,[ ? , - 0X . P& *( " P$ Z T _ B 0 ? $* " 2H

RealValue_DynamicFormat = SUMX(KPI_List,[ B ])

* Format &;, P / , Formatting Measure Tools * , , 8 6 L ^ & *( " Z T , =5

.(6 &A ) ZT Dynamic Format -

6 &A

" ;ZT 6 D!B * !/ B 4 - *( " $ **P * $ 0& H & *( " : 9 H R/ B F* 4 ZT

. $ - 0 X *( " : 9 R/ B 7 &A . ; C K &

4
 ( %&$ ' - !" # $ – -

7 &A

*^#/ $ K " &5 R/ B , " 6 &5 R/ B *( " 0& H : 9 i * < 8 0& H & * ; * ; *>& * 3 4 *

K" " ; *H 0& H & qM 9" * 6& * Format &;, * , R/ B *( " 4 Z T . " $ _ B 4 , 3 @+H

.( 8 9; &A * )

8 &A

g C K R/ B *" K K F !X + K" + *" & / , P& &- ^ & / H & 9;

R * " * qM , $R/ B K " $R/ B 8 3K (;) 4/ 3 9" 0& -*`+ , _P 9$ AB 4 M .

g & / 8 @+H * Y &A DX . 5 !X R/ B , 3g $R/ B 8 $ . &; K" K K F !X

. 5& / 4 , K K !X * " *" $ F ;

4 , 2 &A . &; 9 $ j * " 6 F s /- *E& :T K " R/ B 8 * W AT 0& -*`+ ,

: " K * 58 &; _ ! K * 8M& ; P *( " , < 58 ;,& Q $ H 7& &

RealValue_DynamicFormat = SUMX(KPI_List,[ B ])-58

* I( , &; : 9 6 K 1B X < !X F? “0.00;;0” R/ B , K" ] 4 , =5

D *& 4 _ / 4 9$ * &; * ;& 4 R/ B & /* B . &; 9 : 9 4 F " * ;& I& / K

. ! 9 &A R/ B 4 g *( . " * H B 0&B _+

5
 ( %&$ ' - !" # $ – -

9 &A

9; P > L9 4 &; K"C K $& / , K !X F K * $ 6 *( " R/ B I &5 7& 4 "0X 4

& ; ; -. 0 > , 6& " 8 : 9 & / 0 X 6& * . *( " : 9 R/ B g = C &" , K " 63

. ! 10 &A R/ B 4 , K " *( . K" , &" ,

SELECTEDVALUE( KPI_List[FormatString] )

10 &A

6, $ B, K" * 3 4/ & 9; F ; ; -. 0 > $6& " , 3 H & / 9< /* 4 2

u $ R/ B 4 , K " *( .& _ ! 4 * $ K" , & " , Format d , K" 6 * !/ $ 9; Dax

.(11 &A ) $ 4 , :5* ; K

SWITCH( SELECTEDVALUE(KPI_List[W- ;]),

"PCC", "#,# KWh",
"OEE", "#.#%",
"ASR", "#.#%",
"AFR", "#,#.00",
"R_Return","#,#,,.0 M IRR",
"D_Return","#,#,.0 K $",
"#,#.#"
)

6
 ‫‪( %&$ ' -‬‬ ‫‪!" #‬‬ ‫‪$‬‬ ‫–‬ ‫‪-‬‬

‫‪11‬‬ ‫‪&A‬‬

‫* ﻣﻨﺒﻊ ﻗﺎﺑﻞ اﺳﺘﻔﺎده ﺑﺮای آﺷﻨﺎﺋﯽ ﺑﺎ ﮐﺎرﮐﺘﺮﻫﺎی ﻣﻮرد اﺳﺘﻔﺎده در ﺗﻌﺮﯾﻒ ﻗﺎﻟﺐ ﺳﻔﺎرﺷﯽ‬

‫‪[Link]

‫ا ﻦ راﻫﻨﻤﺎ ﺑﺨﺸﯽ از ﻣﻄﺎﻟﺐ ﻣﺮﺑﻮط ﺑﻪ راﻫﻨﻤﺎی زﺑﺎن ‪ DAX‬اﺳﺖ ﮐﻪ در ﮐﺎﻧﺎل ﻠﮕﺮا ﯽ ‪ [Link]/Power_of_BI‬ﻣﻨﺘﺸﺮ ﯽﺷﻮد‪ .‬ﺑﺮای‬

‫دﺳﺘﺮﺳﯽ ﺑﻪ ﺳﺎ ﺮ ﻣﻄﺎﻟﺐ ﻣﺮﺑﻮط ﺑﻪ زﺑﺎن ‪ ،DAX‬زﺑﺎن ‪ ،M‬ﭘﺎور ﮐﻮﺋﺮی‪ ،‬اﺻﻮل ﻃﺮاﺣﯽ داﺷﺒﻮردﻫﺎ و ﭼﺎﻟﺶﻫﺎی دﻧﯿﺎی واﻗﻌﯽ ﺑﻪ ا ﻦ‬

‫ﮐﺎﻧﺎل ﻠﮕﺮا ﯽ ﺑ‪BC‬ﻮﻧﺪﯾﺪ‪.‬‬

‫‪7‬‬