All DAX calculations gives an error

[Yrstruly2021]

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 

[Yrstruly2021]

I did that.

[Yrstruly2021]

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 

[tamerj1]

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.

[tamerj1]

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