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 All,
I have tried different solutions for YTD formulas from this forum for my work but none seems to work. I suspect it my be due to the specific nature of the SQL(Directquery) I am using. See a screenshot:
HI @MikeMCFRS ,
I'd like to suggest you use the date function to manually defined filter range, time intelligence functions seem not fully works on live mode.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
@v-shex-msft , Can you explain a little further on what you described as the filtered range. I have tried using the suggested formula but to no avail. I created a formula that converted YES to 1 and NO to 0 ,based on which I calculated the value for summing up the YTD but still not working for me.
Any Ideas??
HI @MikeMCFRS ,
Your visuals only contain month field as category, I don't think time intelligence functions can work on single month fields. (in your row contents, it mix all year records, so YTD function not works)
I think your formula should works if you add the year to your visual as category field.
If you still confused about coding formula, please share some dummy data with minimum table structure for test.
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |