Fixed date dax calculation

[meerzaheenn]

Hi,

I'm very new to Power BI and thus, I'm not sure how to properly ask the question I have.

This is my requirement:

My SQL currently holds 7 days worth of data.

Job does not run on weekends and thus Saturday and Sunday delta will be available on Tuesday on PBI report

Monday's delta will be available on Wednesday on PBI report

Tuesday's delta will be available on Thusday on PBI report

Wednesday's delta will be available on Friday on PBI report

Thursday's & Friday's delta will be available on Monday on PBI report

Sample Data:

I added Day of the week and Weekday and tried to fingure top N on the DATE column but it not did work as expected

Its very complicated for me. If I can get some help to approach this, it will be great

Thank you!

[v-lili6-msft]

hi  @meerzaheenn 

What is your expected output for this sample data?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[simrantuli]

Hi,

Not clear what exactly you want to achieve in Power BI. Would be great if you could explain a bit more.

Regards

[amitchandak]

@meerzaheenn , not very clear with to me.

do you only want to work with work day

part of this can help https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...

Or do you need rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

Can you share sample data and sample output in table format?