Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am using the Adventure Works 2020 Data Model. I have included a simplified example of the tables.
I would like to create a measure that would allow me to display the number of orders per day or other period specified in a chart. I have been able to create a table using the following DAX code:
but I am having trouble getting to returing a single value required for a measure in a chart.
Thanks in advance.
The best solution is reshape the input data to 1 calendar dimension table and 1 fact sales table using PowerQuery.
Then the DAX is easy. Howvere ,if you want or need to do it the hard way ....
Create 2 new measures
HI @BIstudent
It looks like you have made a mistake in the name of the Table "Dates"
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@BIstudent in this case, you could have created a simple measure like below and then it will accordingly will show the data as per time period selected (year, month, week, day etc.) in your visual
Orders_daily = distinctcount(sales_order)
let me know if i am missing something here.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |