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.
Hello all, I don't know why MTD cannot be calculated correctly using below formula, while the one using quick measure is work.
Is there is anything wrong on the formula?
Here is the file:
https://drive.google.com/file/d/1880pWiT-tyujOM9Gl9l1ioD68OM7E870/view?usp=share_link
Thank you!
MTD Sales = CALCULATE(SUM(Orders[Sales]),DATESMTD(Orders[Order Date]))
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Great thanks!! 🙌
I followed your file and applied the changes to the other file and it works!
May I know why to add these?
- Add Calendar table, add relationship
- Add a new measure which is sum(orginal sales field)
hi,
The presence of a Calendar table allows one to use the Date/Time Intelligence functions. One should always write explicit measures rather than dragging bare numeric fields to visuals. This allows one to use those measures as inputs when writing other measures.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |