Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |