Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago

Dax need

You will see that there is a quarter selection on dashboard:       This selection comes from an excel file, however it is not great because users sometimes forget to update this excel file....
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Nihed , You need to create column like this in your date table and save that in This Qtr

 

Switch( True() ,

format(today(), "YYYY - \QQ") = [Qtr Year] , "This Qtr",

[Qtr Year]

)

 

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

  • Nihed's avatar
    Nihed
    Icon for Helper III rankHelper III
    4 years ago

    thank you for your answer
    just for information I don’t have a date table in my report I use an EXCEL file with this data and I wanted to create this data in a direct dynamic table to have  "QUARTER SELECTION " in Power BI how I can do please?

    the data of the execel file:

     

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, Nihed 

      You can try following code  to manually create a calendar table to replace data in EXCEL file.

      Calendar date = CALENDAR(DATE(2017,01,01),TODAY()) //calculated table

      calculated columns:

      Quarter = FORMAT('Calendar date'[Date],"YYYYQ")
      Num quarter = 
VAR _year =
    YEAR ( TODAY () )
VAR _quarter =
    QUARTER ( TODAY () )
VAR _last_quarter =
    IF ( _quarter = 1, _year - 1 & "4", _year & _quarter - 1 )
RETURN
    IF (
        'Calendar date'[New quarter] = _last_quarter,
        "last quarter",
        'Calendar date'[New quarter]
    )

      Due to the use of calculated table, you still need to refresh the calendar table to get the latest data.

       

      Best Regards,
      Community Support Team _ Eason

      • Nihed's avatar
        Nihed
        Icon for Helper III rankHelper III
        4 years ago

        Hello,

        It works very well I did exactly the same thing, thank you very much for your help

         

        Thank you.