Forum Discussion

sqlguru448's avatar
sqlguru448
Helper III
6 years ago

Complex Dax Measure - Help Needed

Hello Folks,   I have a complex requirement in Power BI reporting which is sourced from Azure Analysis Services Tabluar Model via Live Connection. I cannot change the Tabular model, so the measure ...
DAX
Get Help
measure
CNENFRNL's avatar
CNENFRNL
Community Champion
6 years ago

Hi, there, pls refer to the following calculated table formula for details,

 

Debug = 
VAR _summary =
    SUMMARIZECOLUMNS (
        dCust[Customer],
        dLoc[Location],
        dProd[Product],
        fSales,
        "Times", COUNTROWS(dDate),
        "MinDate", MIN ( dDate[Date] ),
        "MaxDate", MAX ( dDate[Date] ),
        "Interval", INT ( MAX ( dDate[Date] ) - MIN ( dDate[Date] ) )
    )
VAR _tb =
    FILTER ( _summary, [Interval] > 0 && [Interval] <= 7 )
RETURN
    _summary

 

 

or change the last line to turn it into a measure

 

RETURN
    --_summary
    CONCATENATEX(_tb, [Customer], UNICHAR(10))

 

it's based on a most idealized data model