cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeMCFRS
Helper III
Helper III

Need help With YTD

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:

 
 
 
4 REPLIES 4
MikeMCFRS
Helper III
Helper III

Screenshot (105).pngScreenshot (107).png

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!