Need Help : SSAS DAX Expression RRS feed

  • Question

  • Hi Team,

    I have a DAX requirement in SSAS Tabular Model.

    DAX Expression used:

    Last Week Quarter Bucket = 
        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:



    Wednesday, September 2, 2020 5:44 AM


All replies

  • 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
  • I'd try asking for help over here.




    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