Forum Discussion

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Atch 

     

    I try the same measure in my side, but no error.

    Could you please share your data(without sensitive data), or create a set of sample data.

    And describe the target you want in detail, so that we can help you better.

    How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community

     

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Atch's avatar
      Atch
      New Member
      2 years ago

      I have sensitive data 

      but I can explain more 

       

      I have date column from 8/1/2022 to till today 2/9/2024  , fiscal weekend column  which only weekend dates of 8/1/2022 to 2/9/2024

       

       

      i have another date column using the Dax 

      IF(FiscalDateTable[Fiscal Year]=MAX(FiscalDateTable[Fiscal Year])-1,FiscalDateTable[Weekend Date]+364,FiscalDateTable[Weekend Date])

      Im using this date in date slicer so when I slice it has to show 2022 weekend date data , also 2023 weekend date data 

       

      but it showing future weekend date also like this 

       

    • Atchaya-Prabhu's avatar
      Atchaya-Prabhu
      New Member
      2 years ago

       I have no option to attach it,
      Date formula

      DateTable = CALENDAR(DATE(2022,08,01), TODAY())

      Weekend date formula

      Weekend Date = [Date] + 6 - WEEKDAY([Date], 2)

      Fiscal year formula

      Fiscal Year = IF(MONTH([Date]) >= 8, YEAR([Date]) + 1, YEAR([Date]))

      date 1 formula

      date 1 = IF(DateTable[Fiscal Year]=MAX(DateTable[Fiscal Year])-1,DateTable[Weekend Date]+364,DateTable[Weekend Date])

       

      Using date 1 column as a slicer in the visual

      Here you see date from 8/5/2023 to 8/3/2024 but i want to see till latest weekend date for example till  02/03/2024 , whwenever it refreshes it has to show  recent weekend date only like  tomorrow it refreshes to see 2/10/2024, in my case it shows everything till 8/3/2024..

      When date 1 column sorts descending it has to show from initial date  08/05/2023 to till latest weekend date i hope this helps.. i have no option to attach my pbi file...

      i have 2 accounts so replied in different account.kindly help