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  ...
daxhelp
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