Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
I did that.
I have hanged my data types, i believe it is correct now. Still i dont get data back, example: "
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.
Hi @Yrstruly2021
You need to set the correct data type (Decimal) in power query
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |