User Profile
Jessica07
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Gen 2 Dataflow Can't click [Next] in add Data Destination
In Gen2 Dataflow, add a data destination, one of the dataflows suddenly becomes unable to go to the [Next] step in the add data destination. It was working fine before, but stopped working today. The same method is working on other dataflows in the workspace.How to recreate the "or" condition filter in PBI Report Builder
Hi, I'm trying to recreate a report from Powerbi Desktop to Report Builder. I have an issue when I recreate the filter for Allocation.TotalCost with conditions (is greater than $0 OR is Blank). When I rebuild the filter in Report Builder, I used "Custom" in the query editor with the expression "IF('Awards'[RMS.Allocation.TotalCost] > 0 || ISBLANK('Awards'[RMS.Allocation.TotalCost]), 'Awards'[RMS.Allocation.TotalCost], BLANK())". But this resulted in a few hundred rows missing in the output. How can I recreate this "Or" (is greater than $0 OR is Blank) filter in Report Build and still have the same rows returned? Thank you. Your help is greatly appreciated! Powerbi Report Builder: Powerbi report filterRank changing based on date for each sub-group
I have a table containing data of ProjectID and each ProjectID has multiple periods. Each ProjectID is like a sub-group in my data in 'ProjectID' column. Each ProjectID has multiple period numbers that are shown in a column called 'RMS.Allocation.PeriodNumber'. I want to always get the lasted period for each project when filtering the date range. This means the period rank needs to change along with the date period changes. How can I do it? Appreciate your help in advance!
