User Profile
shri2785
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Matrix with different grain
Dear 123abc, thanks for your quick reply. Yes i have implemented the SUMX as mentioned for revenue by city but now the challenge is that the Measure cant be added to Rows of Matrix visual. If possible can you share the pbix file where u have added the Revenue by city to Matrix visual on Rows. Thanks!1.2KViews0likes1CommentMatrix with different grain
Dear Power BI Guru's Being new to PBI , trying to resolve on situation at my end Below is the requirement The Sales orders should be shown at hourly basis, based on the city and Revenue per City. Sales order is calculated on time / hourly basis where as Revenue at city. 1:00 AM 2:00 AM 3:00 AM 4:00 AM 5:00 AM 6:00 AM 7:00 AM 8:00 AM 9:00 AM 10:00 AM 11:00 AM Revenue City 123 23 21 12 34 54 23 35 90 78 67 $4,500 I have added the Matrix to aggregate the sales orders at hourly but when i add the Revenue the matrix fails to add. Little background: Fact table with Sales order detail is joined with Dim calendar One of the transaction datetime is split into hour column ex 2023-12-20 02:38:45 PM as 02:00 PM using dax Based on the hour column we are aggregating the sales order in matrix. Revenue is the sum(net sales) Please revert if more info reqquired. Thanks!Solved1.2KViews0likes4CommentsRe: Issue with Constant date value in slicer
Hi Wilson, thanks for the response, and it worked for me. I am trying to create a slicer with the list of dates to be passed for measure calculations. There is one more hurdle i am facing we have something called as ficsal_period_start_date in dim_cal when i try to reference to this it give me circular ref error. May i know how we can get this done... Basicall i need YTD QTD PTD as slicer options.Thanks708Views0likes0CommentsIssue with Constant date value in slicer
Hi Power BI Gurus, I have tried to create a slicer for YTD, QTD, MTD using some links on web. Below is the code for the same Time_Frame = VAR TodayDate = Today() VAR YearStart = Calculate(STARTOFYEAR(Table1 [POSTING_DATE], Year(TodayDate) = Year(TodayDate))) VAR QuarterStart = Calculate(StartofQuarter(Table 1[POSTING_DATE]), Year(Table 1[POSTING_DATE]) = Year(Todaydate), Quarter(Table 1[POSTING_DATE]) = Quarter(Todaydate)) VAR MonthStart = Calculate(STARTOFMONTH(Table 1[POSTING_DATE]), Year(Table 1[POSTING_DATE]) = Year(Todaydate),Month(Table 1[POSTING_DATE]) = Month(Todaydate)) VAR Result = Union ( AddColumns ( calendar (YearStart, TodayDate), "Selection", "YTD" ), AddColumns ( calendar (QuarterStart, TodayDate), "Selection", "QTD" ), AddColumns ( calendar (MonthStart, TodayDate), "Selection", "MTD" ) ) RETURN Result But this results in an error: Only constant date value is allowed as a year end date argument But when i change the code to below Time_Frame = VAR TodayDate = Today() VAR YearStart = Calculate(STARTOFYEAR(Table1 [POSTING_DATE], "12-31-2023")) VAR QuarterStart = Calculate(StartofQuarter(Table 1[POSTING_DATE]), Year(Table 1[POSTING_DATE]) = Year(Todaydate), Quarter(Table 1[POSTING_DATE]) = Quarter(Todaydate)) VAR MonthStart = Calculate(STARTOFMONTH(Table 1[POSTING_DATE]), Year(Table 1[POSTING_DATE]) = Year(Todaydate),Month(Table 1[POSTING_DATE]) = Month(Todaydate)) VAR Result = Union ( AddColumns ( calendar (YearStart, TodayDate), "Selection", "YTD" ), AddColumns ( calendar (QuarterStart, TodayDate), "Selection", "QTD" ), AddColumns ( calendar (MonthStart, TodayDate), "Selection", "MTD" ) ) RETURN Result The error goes away. I understand that it needs a constant value but i Also need that to be dynamic in nature. Can anyone help. Note: the change is on the line "VAR YearStart = Calculate(STARTOFYEAR(Table1 [POSTING_DATE], "12-31-2023"))" ThanksSolved796Views0likes2CommentsRe: PBI and SAP BW connector issue
Hi There, Thanks for the quick response. We had tested it with other accounts which had higher access level but failed with same error. We changed the PBI version to 2019 and checked, this version is supporting the SAP BW connection without any hassels.1.1KViews0likes0CommentsPBI and SAP BW connector issue
Dear PBI Gurus, We are trying to make a connection between PBI desktop to SAP BW Source system at client end. We are able to provide corporate id to login to PBI (which is different from client id) and trying to connect to SAP BW of client server. We have server details and SAP id to logon, we can see the server Name, objects, queries When we are trying to run a query as direct mode (which is parameterized) we enter mandatory values and hit Load button Post which it starts loading data and ends up with an error: . Cube SAP Business warehouse : Object reference not set to an instance of an object. We have tried below links and options with no luck https://urldefense.proofpoint.com/v2/url?u=https-3A__learn.microsoft.com_en-2Dus_power-2Dbi_connect-2Ddata_desktop-2Dsap-2Dbw-2Dconnector&d=DwMFaQ&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8IrwNKOtkVU&r=6dJ1n65YHGlruhj0w8msSpeYCvx7BOUBcv0Z2GaHpGo&m=OYTfiOdKYgDYhMUPSyL7QnxYZGr-_49IwYbEIVij8otggXQs0xYXFnel_1NOGaq0&s=VsJ6BKY10g-c_cAYUQOlBbnl9pN5v-sYwckr8mwZCM8&e= https://blogs.sap.com/2016/03/31/microsoft-power-bi-and-sap-bw-data-warehouse-connectivity-step-by-step/#:~:text=Microsoft%20Power%20BI%20and%20SAP%20BW%20Data%20Warehouse,the%20Cubes%20%28Essentially%20the%20BEx%20Queries%20underneath%29%201.2KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.