Forum Discussion
Helper IMeasure dissapers when published file refreshes
I think I did it
- While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
Super UserHi Dwivedi15
The issue with the BudgetMeasure_HD disappearing might be due to incorrect data in the Source column, filters, or slicers affecting the measure. Ensure that both "Actual" and "Budget" values are properly populated in the Source column of the combined table. Check that the union of the "Actual" and "Budget" data is working correctly and that the correct rows are being combined. Test the measure in simpler contexts (e.g., without slicers) to rule out filter-related issues. Additionally, clear the cache and refresh the model to address any caching problems.
Helper II think I did it
- While this data was getting merged in transformation- Date was treated as text and not Date, therefore all the data of Date field after refresh beacuse of BI Service- was overwritten as text ( Although in DAX I converted that filed into date - using normalisation of the filed and created new column) , which then telling that model to treat date as MM/DD/YYYY instead of DD/MM/YYYY.
Hi, Dwivedi15
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.