Forum

Hi, In D2 on the "Consolidated" sheet, you can use this formula: =IF(C2="","",A2&B2&"/"&ABS(C2)&"_"&COUNTIF(C$2:C2,C2)) a...

Hi, Please try uploading the screenshot again, or even better a sample file. Don't forget to press the "Start upload" button before you submit your...

Hi, Initially, I hadn't paid attention to your question as it referred to VBA, but perhaps you can live with a solution that uses data validation. ...

Hi Bob, The file didn't come through. Please ty again and don't forget to press "Start upload" before submitting your reply. Riny

Hi Koen, I used the following formula in F2 on the transactions sheet: =LOOKUP(1,XMATCH("*"&TBL_Keywords1[Keyword]&"*",[@Description],2)...

Hi Sasaki, Please have a look at the attached workbook. It contains an example of what you described. The CF rule used in Sheet1 is as follows: ...

No, but you can easily replicate it by group/count and then merge the Source with the Grouped table. See attached.

Since you are on-line now and Mynda is not, please allow me to help you. The applied step Inserted Day Name contains a reference to the [Int.] colu...

Great! I'm not into DAX so much myself, so I didn't know.

Can you upload a file with some anonymized data that resembles your real data and indicate how you would dense-rank it manually?

Hi Chris, Wondering where the date comes in in relation to the time. Do you currently have a formula in the date column? If so, what is it? If y...

Perhaps the link below helps you to get started with Dense Ranking in PQ.

Hi Steve, I did a smaller scale experiment, connecting to a sheet in a workbook where I entered some data in Sheet1 in the first few columns and a ...

Hi Martin, That requires a trick in Power Query where you append the new pricelist to the current list, remove duplicates, group, sort and keep the...

Hi Christina, I would suggest you use PowerQeury to transform your raw data. Load the result to the Dashboard and create the slicers off that table...