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...

Can't see the image, but generally speaking, when you want "all possible combinations", you need a CROSS JOIN between two tables... If you had a table of Courses and...

I'm not sure it matters if the table has data or not...

If you run some TSQL to append the data to the Archive table, and then run another that truncates...

Like this?

CREATE TABLE TABLE1

(IDint,

XDATEdate );

CREATE TABLE TABLE2

(XDATEdate );

GO

insert into TABLE1 (ID, XDATE) values

(100,'20150505'),

(100,'20150506'),

(100,'20150507'),

(222,'20150505'),

(222,'20150506');

insert into TABLE2 (XDATE) values

('20150505'),

('20150506'),

('20150507'),

('20150508');

SELECT t1.id, t2.xdate as t2date

FROM table2 t2

LEFT JOIN table1 t1 on t1.xdate=t2.xdate;

Why not...