User Profile
vivran22
Community Champion
Joined 7 years ago
User Widgets
Contributions
Re: Merging two columns
Hello Anonymous , Where you are appending the tables? Try changing the name of this column in Power Query. Cheers! Vivek If it helps, please mark it as a solution Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!) If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image) https://www.vivran.in/ Connect on LinkedInRe: How do remove a specific number of digits based on the number of digits in a different column
ThomasWeppler Considering they are number columns, you may also try the following: Extract Num = VAR _Sub = 'Test Table'[Col1] * 10^(LEN('Test Table'[Col2]) - LEN('Test Table'[Col1])) VAR _Diff = 'Test Table'[Col2] - _Sub RETURN _Diff Cheers! Vivek If it helps, please mark it as a solution Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!) If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image) https://www.vivran.in/ Connect on LinkedInRe: Need Help in visualizing
Hello alalan I do not think you need to create a separate table for the grouping, also the many-to-many relationship may not be helpful for filtering the fact table. Is it possible to share the sample fact data/pbix file? Cheers! Vivek Blog: vivran.in/my-blog Connect on LinkedIn Follow on TwitterRe: Change column value based on slicer
Hello Pat8 , You may try this: Selected Measure = VAR _PrevMonth = PREVIOUSMONTH('Table'[Month]) VAR _Calc = SELECTEDVALUE('Table'[Amount]) - CALCULATE(SUM('Table'[Amount]),PREVIOUSMONTH('Table'[Month])) VAR _Check = IF(NOT ISBLANK(_PrevMonth),_Calc) RETURN _Check Cheers! Vivek If it helps, please mark it as a solution Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!) If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image) https://www.vivran.in/ Connect on LinkedIn
