topic All DAX calculations gives an error in DAX Commands and Tips

All DAX calculations gives an error

Yrstruly2021 — Sat, 03 Sep 2022 12:16:51 GMT

Please assist. I tried to do calculations and it gives an error for all of them.

I chnages the following DAX code to what i have in my tables:

Margins LQ = CALCULATE( [Profit Margins], DATEADD( Dates[Date], -1, QUARTER ) )

QoQ Sales Change = [Total Sales] - [Sales LQ]

Sales 1M MA =

AVERAGEX(

DATESINPERIOD( Dates[Date], LASTDATE( Dates[Date] ), -1, MONTH ),

[Total Sales] ) and

Cummulative Sales =

CALCULATE( [Total Sales],

FILTER( ALLSELECTED( Dates ),

Dates[Date] <= MAX( Dates[Date] )))

https://drive.google.com/file/d/1roS73IxPmTE4vFPPRNFkglaH5uuzhXBq/view?usp=sharing

Re: All DAX calculations gives an error

tamerj1 — Sat, 03 Sep 2022 12:39:18 GMT

Hi Yrstruly2021
You need to set the correct data type (Decimal) in power query

Re: All DAX calculations gives an error

Yrstruly2021 — Sat, 03 Sep 2022 14:06:42 GMT

I have hanged my data types, i believe it is correct now. Still i dont get data back, example: "

Sales LY = CALCULATE([Total Sales], DATEADD('Calendar table'[Date], -48,MONTH))"

https://drive.google.com/file/d/1onm3FkDOuG-C3Paw9BLgtZnvkUBbc_Ui/view?usp=sharing

Re: All DAX calculations gives an error

Yrstruly2021 — Sat, 03 Sep 2022 15:29:18 GMT

I did that.

Re: All DAX calculations gives an error

tamerj1 — Sat, 03 Sep 2022 17:06:55 GMT

Hi Yrstruly2021

https://we.tl/t-wvUyhckJ9W
The orders Created_DateTime column contains time in addition to date. Therefore, it matches zero dates in the calendar table. I have created a Created_Date column and linked it with Calendar[Date] and now your measure works. However, I noticed that the year slicer still have blanks, so I adjusted the start date of the calendar table to MIN ( Orders[Create_Date] ) but still have blanks. I believe your data model and requires an overall check to clean up everything.