Forum Discussion
Fixed date dax calculation
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!
3 Replies
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-Calendar-4-5-Power/ba-p/1187766
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/367415Can you share sample data and sample output in table format?
Hi,
Not clear what exactly you want to achieve in Power BI. Would be great if you could explain a bit more.
Regards
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/38490Regards,
Lin
