Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Need Help : SSAS DAX Expression RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Team,

    I have a DAX requirement in SSAS Tabular Model.

    DAX Expression used:

    Last Week Quarter Bucket = 
    CALCULATE(
        LASTNONBLANK('Account'[Quarter Bucket],1),
        FILTER('Account', 'Account'[Week Bucket] = "-1")
    )

    Based on the above DAX Expression, i am getting the result as in Column D. Can someone help me with the DAX Expression to get the resultset as per Column E.

    Result Screeshot:

    Thanks

    Santosh


    Wednesday, September 2, 2020 5:44 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi SantoshKumarS,

    Thank you for posting here.

    I have moved the thread to 'where is the forum for ...?' forum to help you find the correct forum to go ask questions.

    Thank you for your understanding.

    Best Regards,

    Xingyu Zhao

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, September 3, 2020 1:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd try asking for help over here.

    https://docs.microsoft.com/en-us/answers/topics/sql-server-analysis-services.html

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Guido Franzke Thursday, September 3, 2020 6:37 AM
    • Marked as answer by Dave PatrickMVP Tuesday, September 8, 2020 1:16 PM
    Thursday, September 3, 2020 1:41 AM