Forum

Hi Lalith, Welcome to our forum! To apply conditional formatting bars to the percentages in column F (Percentage of the project completed), firs...

Hi Frans, I love a challenge like this 🙂 You need to use OR Boolean logic (the + signs between the criteria), to return the columns you want: ...

In my example the user only needs to choose the ID once, either in the Slicer, or in the filter either in the PivotTable, or if you prefer to have the...

Have you tried rebuilding that query from scratch? Have you tried rebuilding it in a separate file. It sounds like something has become corrupted in t...

Hi Luna, This error usually means that the column headers in the source data have changed/are different to what they originally were when the query...

Hi Aye, I'm not sure as these aren't covered in the course and I haven't used them yet myself. Please see this help topic. Mynda

Hi Nikki, Welcome to our forum! You'd need another column with the actual completion date. So, you'd have two end dates, one for target end date...

And using the arrow key to select one cell at a time is your desired result? If you prefer, you can use the PivotTable Filters to search for the produ...

Hi Petek, Welcome to our forum! This is a known issue with combo Pivot Charts. You can try editing the date/year field settings to 'show items w...

Hi Lukasz, The layout of your data is wrong for a Pivot Chart. If it were in a tabular layout you could use Slicers to select different products to...

Hi Maree, The YEAR part of the formula doesn't have parentheses. Please look at the formula I gave you again, you'll see it only has two closing pa...

Hi Maree, You can write a measure like this: Moving Annual Total: = CALCULATE( SUM(TransactionData[Sales]), DATESINPERIOD(CalenderTable[Date],LA...

Hi Alexis, Welcome to our forum! Why don't you just remove the folders from the Source Data folder that you don't want included in your report anym...

Glad you got it working, Aye.

Hi Ivan, If you want to take your DAX to the next level, I recommend this course. Mynda