User Profile
Molin
Helper I
Joined 5 years ago
User Widgets
Contributions
Calculating Payback period using DAX
Dear community, I am struggeling with at DAX measure to calculate (count) the payback period in months. Unfortunately, I have little flexibility in datamodel, meaning calculated columns is not an options. Working on a DAX measure, I need to count the months when "Cashflow Rolling" is bigger than "Total Investment" (see picture below). Both "Cashflow Rolling" and "Total Investment" is measures, with "Total Investment" having a REMOVEFILTERS on the DimDate table [YearMonth] is related to. In excel I would use =MATCH(), however I cannot find a similar measure in DAX. Thank you in advanceRe: Creating unique table without duplicate values
Hi DataNinja777 , Thank you so much for the quick reply and detailed explanation on the formula. I have tried to follow your steps and get unique values for all relevant [GuestCheckId], however the new calculated column "Latest_Reference" is blank for all rows. Can the datatype effect the statement? 'TransactionDetails'[PostingTime] is Date/Time format, while TransactionDetails'[Reference] is a String. Thank you so much for your time and sharing knowlegde. Best RegardsCreating unique table without duplicate values
Dear community, I am trying to create a calculated table using DAX to list the unique [Reference] times for each transaction. However, some transactions have more than one [reference] time and I would like the list only the latest based on [PostingTime]. So far I have managed to create the table, however filtering on one unique row is causing problems. PU Times = CALCULATETABLE ( DISTINCT ( SUMMARIZE ( 'TransactionDetails', 'TransactionDetails'[Reference], 'TransactionDetails'[GuestCheckId] ) ), ''TransactionDetails''[ObjectNumber] = 999000009, DISTINCT ( 'TransactionDetails'[GuestCheckId] ) ) The large 'TransactionDetails' table looks like this, filtered on [ObjectNumber] and a single transaction As I am using incremental refresh, it prohibit me from "removing doublicates" in Power Query. Thank you very much in advance.Calculating groups
Dear community, I am facing a challenge to group sales from a fairly simple table. The table have total sales generated on both "OrderType" and "SalesChannel" which sums up to the same. However I would like to change the setup with the following needs, preferably through dax (running direct query): "Dining-In Sales" should only appear once "Pick-Up Sales" should be zeroed "Online Sales" should be calculated as follows: Online Sales - all Providers Sales The decired result you can see on the right hand side. Thanks in advance.
