Tableau formula to dax
I'm currently in the process of transitioning Tableau reports to Power BI, and I'm encountering challenges with converting certain Tableau formulas into DAX expressions. One formula in particular has me stumped, and I'm seeking assistance to translate it. The Tableau formula involves the use of the FIXED function, which I'm not familiar with, and I'm unsure how to replicate its functionality in DAX. Here's the Tableau formula: IF { FIXED [Sales Document]: COUNT( IF [OT RDD HDR Flag | T,F] = TRUE AND [IF RDD HDR Flag | T,F] = TRUE THEN [Sales Document] END ) } = {FIXED [Sales Document] : COUNTD([Sales Document Item])} THEN 1 ELSE 0 END Any guidance or assistance with this translation process would be greatly appreciated."
Employee Retention, Filtering Based on Job Title and Business Location
Hi everyone, Thanks to this group I managed to work on my dax to calculate retention % for the business. However, the problem that I'm experiencing is when I tried to filter my visualization based on Job Title or Business Unit code, my measure doesn't change in line with the filter. My aim is to see retention % based on different business units and job title's so we can identify possible challenges for retaining talent within the organization. Here is my DAX: Thank you so much for the support! Retention % = VAR _Previous12START = EOMONTH ( MAX ( 'Calendar'[Date] ), -13 ) + 1 VAR _Previous12END = EOMONTH ( MAX ( 'Calendar'[Date] ), -1 ) VAR _LEFT = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] >= _Previous12START && 'Master Data'[Date Engaged] <= _Previous12END && 'Master Data'[Date of Resignation] >= _Previous12START && 'Master Data'[Date of Resignation] <= _Previous12END ) ) + 0 VAR _Total = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] <= _Previous12END && OR ( 'Master Data'[Date of Resignation] >= _Previous12START, 'Master Data'[Date of Resignation] = BLANK () ) ) ) RETURN 1 - DIVIDE ( _LEFT, _Total ) This is how the visualization look like:How to calculate the difference between two rows of a single column in power BI
Hi, How to calculate the difference between buy and sell of a salesvalues coulmn based on country by converting to rows to column of buy_sell column . Input: Country category buy_sell salesvalues India A buy Null India A sell -75,500.00 USA B buy -60,095 USA B sell 70,901 AUS C buy 29,923 AUS C sell -3,260,307 AUS D buy -60,750.00 AUS D sell -1500 USA E buy 10 USA E sell 20 USA F buy -20000 USA F sell Null Expected Output: Thanks, SBCCount of each month by year
I have two dates as created date and closed date. sample data as below, Created Date Closed Date 20 February 2019 2 March 2019 21 February 2019 10 March 2019 1 March 2020 4 April 2020 1 January 2021 2 February 2021 10 January 2021 23 February 2021 2 February 2021 5 March 2021 I calculated count of each month by year as below, Created Date Closed Date Created Date Count Closed Date Count 20 February 2019 2 March 2019 2 2 21 February 2019 10 March 2019 2 2 1 March 2020 4 April 2020 1 1 1 January 2021 2 February 2021 2 2 10 January 2021 23 February 2021 2 2 10 Februray 2021 23 March 2021 1 1 When I'm trying to create graph, I am passing Created Date and Closed Date in Axis and in Values i'm passing created date count, closed date count, but on graph not showing the correct count because i'm passing 2 different date's in Axis. I have tried using Calendar table also but while creating relationship it giving me an error: Circular dependancy was detected. Is there any other way to do it, without using UseRelationship Function.Multiple user input
Hi Everyone, is it possible to have a multi user input in power bi? for example i have the below table i need to add an option for the user to add for each index (1 to 😎 a value based on his decision, and these entered values should be used in other calculation (like a predective analysis). i checked the what-if-paramter how the user can select only one value to be evaluated in the report, while here i want all values to be involed in the calculation based on the index number. also in what-if-parameter, we have to specify min max and incremental value, while here values to be entered are not necessarily incrementing. appreciate you assistance. Best regards,
