Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello there, I have this sample data set, I need to create Time intelligence measures for EBIT, Discretionary Trade Spent, Non-discretionary trade spent, Sales etc... When I try using TI method using Tabular editor and creating new tables for measures and selected measures, I am getting same results for all the columns (example: QTD, MTD, YTD, everything comes up as same values ) , I need some suggestions to any alternate methods that I can use or any suggestions on how to resolve this problem please.
Thanks!
Thanks for replying @amitchandak ! Appreciate it. I am following what you have done in your video, created a dim date table, marked it as date table, created 1 to many relationship, still i am getting the result like this...
@Anonymous , Hope you are using date table and Time Intelligence
Refer my example
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
103 | |
98 | |
90 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |