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 - Currently i am currently calcualting WOS = (Latest week Shipment)/(13Week avgshipments) my week is between Monday to Sunday,, if i refresh the file on Wednesday the latest week shipment will be incomplete. so i have choose the previous completed week to do the calcualtion.
Can someone help me??? VERY URGENT
For a more complete answer, please provide sample data and/or screenshots of the data and your model.
Quick down and dirty method: create a calculated column in your date table for all weeks showing whether the week number is less than the current/incomplete week. This column will change every time the data is refreshed and use it as a flag to exclude dates in or after the current week number.
Calculate([WOS], [Is Weeknum less] = 1)
Proud to be a Super User!
Without sample data, this is still just guessing. Please provide sample data and/or screenshots if available. Try this. Keep your latest_week_Inventory measure, add my LatestWeekInventory measure, and create the NewWoS_ST_new measure. don't remove your existing measures, just add my two versions and see if the NewWoS_ST_new works for you.
Add these two:
LatestWeekInventory = CALCULATE([latest_week-Inventory], [Is Weeknum less0=1)
NEWWoS_ST_new = DIVIDE([LatestWeekInventory],[13WeekAvgST_units])
Proud to be a Super User!
Hi @mohan_g_das1986 ,
Can you share more information about your model and expected result?
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 (courtesy of @Greg_Deckler).
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |