Due to the way you have to calculate the current rent, I think your only option is to use a cursor (Yeah, I know, I should probably wash my own...

Doing this in PowerBI or PowerPivot would be really simple if you build a quick data warehouse with dimensions for Time/Date and Employee and a few measures

Sounds like you selected just the

SET @test-2='This is my name';

line and tried to execute just that. if you don't select the previous line, where @test-2 is declared, the...

Read Kenneth Fisher's blog[/url] about it.

Try using a Tally table where you define the numeric type explicitly in the table definition. Normally INT is big enough... then when you join to another table with...

I might be getting somewhere...

Since I only have 3 possible symptoms, and the total combinations is only 3!=3x2=6, I can just create a cheat matrix:

If I put this in...

Try IsDate(Fields!r1RedWalletSentDate.Value)

Sounds like you have data problems in your underlying tables. Why is there anything but dates in this column? Normally, date fields contain either a date value or...

I have a really simple one in PowerBI with only a handful of Patients. It's really small on purpose, because I only need a few records to prove the...

Since you're pretty new here, I just answered your question... but you really should make it as easy as possible for folks to help you. Here[/url] is a good...

Maybe something like this?

UPDATE [Table2]

SET [CCode] = Table1.[CCode]

WHERE [Table1].[TransType] = [Table2].[TransType]

AND [LocID] Like '%' + [Table2].[Location] +'%');

What exactly do you mean by "contains"? Do you mean something other than "equals" Or do you mean something like

set {a, b, c} contains {b}?

How are you determining "contains"...

If you want a couple of good books on DAX, get Rob Collie's book (see http://www.powerpivotpro.com). He's great at breaking things down and explaining them. And you can download...

Did you try something like

SWITCH([Field],BLANK(),...)

?

BLANK() in DAX is like T-SQL NULL. (Not the same, though, I don't think...)

Oh, inherited mess... my favorite! Here's a quick example of using a window function.

SELECT pmts.ID

, pmts.Amount

, pmts.[Status]

, SUM([Amount]) OVER (ORDER BY ID

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW)...

What are N1...N7? Are they the number of days to add to a date?

Maybe this article will help... should be required reading.

Forum Etiquette: How to post data/code on a forum...