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.
Date of creation column is there to do the calculation.
Please help me to do the same using Date Between, Date Add functions.
Please
Used the following formula, Insteasd of 90 days, I want to add month number
Already created calendar table manually. Relationship also defined. Can I proceed with this approach?
You should be able to. Assuming your calendar is set up correctly. Just in your measure use the columns from the data table for the dates and not the column from your sales table for the dates. Give it a shot and if you still have issues or questions upload some sample data and I can take a look.
First thing you want to do is create a dedicated calendar table, set it as a date table, and then use the columns from that table. Then you can use the time intelligence functions correctly.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |