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