Forum

Hi Dave, You didn't mention which Excel version you are using. The attached file contains two possible solutions. One that uses dynamic array funct...

Can't download your file. Tried is several times and in different ways but always get "Couldn't download - something went wrong".

Sorry that I hadn't noticed that you were posting into the Power Bi forum. That explains my 'Excel-answer'. Change the measure to: title = ...

Let's say the date is in A1 then you could do something like this: =TEXT(A1, "dd-mm-yyyy") & " text" If this is not what you had in mind, pl...

You can write a formula like: =IF(ISBLANK(termination_date),"",calculation) Come back here if you get stuck.

EDIT: I must have overlooked post number 9 before I wrote my response below. So, perhaps not everything I mention is still relevant. Fair enough! S...

Oh my! The last thing I would do is work with separate sheets per month. I'd create on large table, just like in the first file you uploaded. Then loa...

Have you considered the use of one or more Pivot Tables? Added on to your file. See attached.

Try this: =MOD(F4,1)-C4 See attached.

Difficult to know what's going on without seeing the file.

Glad you were able to resolve it.

Right-click on a field name that you use to build the visual with and you will still see the 'Show items with no data' option. Can you upload an examp...

Please see attached. It includes three possible solutions for the basic transformation steps. One is based on the example given by Velouria in the thr...

Please upload a file with some (non confidential) sample data showing what you are dealing with. And include the expected result. Then we don't have t...