topic Dax Help in DAX Commands and Tips

Dax Help

pmadam — Mon, 27 Feb 2023 06:31:10 GMT

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

Re: Dax Help

andhiii079845 — Mon, 27 Feb 2023 06:45:11 GMT

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

Re: Dax Help

pmadam — Thu, 02 Mar 2023 04:44:31 GMT

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

Re: Dax Help

andhiii079845 — Thu, 02 Mar 2023 05:29:33 GMT

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