主页 / coding / 问题

问题[dax](coding)

Martin Hope
Seyma Kalay
Asked: 2024-06-04 21:30:54 +0800 CST
  • 6

我正在尝试使用下面的代码创建自定义工具提示。我想向左对齐Result。提前谢谢了。

measure = 
    
    VAR diffs = SWITCH(
                    TRUE(), 
                    [Week%Change@AOP24] < 0,
                    UNICHAR(10004), UNICHAR(10008))
                    //UNICHAR(9989), BLANK())
    
    VAR Result = // Need to align to the LEFT
        "CW @AOP24: " & FORMAT( [CW @AOP24], "$#,0") & UNICHAR ( 10 ) &
        "PW @AOP24: " & FORMAT( [PW @AOP24], "$#,0") & UNICHAR ( 10 ) &
        "Change @AOP24: " & FORMAT(  [CWvsPWatAOP24], "$#,0") & " (" & FORMAT([Week%Change@AOP24], "Percent") & ") " & diffs
    
    RETURN Result
dax
Martin Hope
Seyma Kalay
Asked: 2024-06-01 16:54:40 +0800 CST
  • 5

我想找到MAX(FYandFW num)基于每个来源的内容。

样本数据集：

Source  FYandFW num sum
Company A   202453  1
Company A   202452  2
Company A   202451  3
Company B   202501  4
Company B   202502  5
Company B   202453  6

我正在尝试的是下面的在此输入图像描述

    Amt = 
VAR i = VALUES('Table'[Source])
VAR j = VALUES('Table'[FYandFW num])
VAR t = 
    TOPN(1,
    CALCULATETABLE('Table', REMOVEFILTERS(), i),
    'Table'[FYandFW num], DESC) 


RETURN
    CALCULATE(SUM('Table'[sum]),t , j)

预期答案是Amt = 5 + 1

dax
Martin Hope
Seyma Kalay
Asked: 2024-05-29 19:16:49 +0800 CST
  • 5

我下面有两个 dax 代码运行良好，

Current Week Amt = 
VAR CurrentFiscalWeek = MAX( 'DF'[Fiscal Week num] )
RETURN
CALCULATE(
     [Measure],
    'DF'[Fiscal Week num] = CurrentFiscalWeek
)

Current Week Amt_2 = 
SUMX(
    SUMMARIZE('DF', 'DF'[Source], 
              "fixed" ,[Current Week Amt]),
              
              [fixed])

但第一个没有给出正确的总数。因为Fiscal Week num不同。我Current Week Amt_2为我拥有的每张桌子更改了。但我想知道是否有一种方法可以利用杠杆VAR CurrentFiscalWeek = MAX( 'Inventory'[Fiscal Week num] )，使表格总数可以正确出现？提前谢谢了。

 Source    Fiscal Week num
    Company A       52
    Company B       49
    Company C       48

在此输入图像描述

dax
Martin Hope
Seyma Kalay
Asked: 2024-05-29 15:58:30 +0800 CST
  • 5

下面的代码计算Current Week Amt最新Fiscal Week num = 52可用的。但它无法Fiscal Week num根据Source File.

 Current Week Amt = 
    VAR CurrentFiscalWeek = MAX( 'DF'[Fiscal Week num] )
    RETURN
    CALCULATE(
         [total Measure],
        'DF'[Fiscal Week num] = CurrentFiscalWeek
    )

我有一个不同的数据集Fiscal Week num。我想考虑最新的Fiscal Week num52、49 和 48。有没有办法在代码中利用它？提前谢谢了

Source Files   Fiscal Week num
Company A       52
Company B       49
Company C       48
dax