Forum Discussion

pmadam's avatar
pmadam
Helper II
3 years ago

Dax Help

Hi Team,

 

I have requirement where SSRS report has fixed current year values , previous year values and the variance of both. 

 

I have now got requirement where to in  Power BI report  and it  should no longer be only a static this year vs last year comparison, but instead allows an adjustable time period (ex: last x weeks/months to previous x weeks/months, this period to same period last year, etc.).

 

 

 

Please suggest.

 

Thanks,

Prathy

daxhelp

3 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    Hi Prathy,
    you can create a table and a field with the selcted duration as a text. The DAX measure can than do the correkt calculation via switch. Do you have some anymous sample datas? 

    Filtertext
    compare to last month
    compare to last week
    • pmadam's avatar
      pmadam
      Helper II
      3 years ago

      Hi Andhi andhiii079845 

       

      Im not sure how Switch works but please fidn the attached sample data.

      I have booking data with Date tables in it.

      Kidly sugguest for below filter models.

       

      Filter
      CY Vs PY
      CQ VS PrvQ
      CQ VS PY SameQ
      CM VS PM
      CM VS PY SM

       

       

      • andhiii079845's avatar
        andhiii079845
        Solution Sage
        3 years ago

        Perhaps you upload some non sensitive data via onedrive or something like this. in the best case the pbi file. The structure of the underlaying data has to be clear