Forum

Hi Dana, See lesson 5.06 and use the ODC file method. Mynda

Hi and thanks for sharing your example file. However, it doesn't fully explain the request because the example numbers in the file don't match what...

Hi Yuan, You can try using tooltips for this. Drag the measure to the 'Tooltips' field in the visualisations pane. Mynda

Hi Yuan, You can try using a Power BI Custom Tooltip for this. Mynda

Hi Christine, This is a locale issue. Please see this tutorial for how to resolve it: Power Query Change Type Using Locale. Mynda

Hi Sarfraz, I'm not following what your desired result is. Can you please upload your file again showing the desired result in column E? Mynda

Hi Dieneba, The DATESBETWEEN function ignores the row filter context and simply returns the value specified in the formula. It therefore wouldn't m...

Hi Filipa, I can't really tell what the issue is from the image, but a relationship will be inactive by default if you already have an active relat...

Hi Paul, I would use 'Add column from examples' and then give it a few examples for text with and without the hyphen. That should be enough for it ...

Hi Matthew, I didn't create the dataset, but it's quite common in the real world to budget for something that doesn't happen, or have new expenses ...

Hi Jig, Please see this tutorial: working with time in Excel. Under the heading: Shift Work Timesheets and Overtime If you're still stuck, pleas...

No. The data validation list source field does not accept formulas.

Hi Brett, The file isn't attached. Please click the yellow 'start upload' button after selecting your file and then wait for the grey check mark be...

Hi Kirtiraj, Please start a new thread with specific information about your query. Please address it generally as I may not be the one to answer it...

Hi Richard, The reason you're seeing 04-Apr is because the dates have been grouped by the PivotTable. If you right-click one of the dates in the Pi...