Issue with table visual loading

[johna123]

I am trying to create a table visual with the following columns:

-Customer Number (fact table)

-Customer Name (reference table)

-Days since last call (measure)

-Days since last order (measure)

The problem is that I can either view Customer Number together with Days since last order and Days since last call --or-- I can view Customer Number together with Cusomer Name.

Whenever I pull in Customer Number, Customer Name, and one of the measures I get the spinning wheel which just goes on and on and the data never populates.

The meaures are as follows:

Days since last order: DATEDIFF([last call date],[Today],DAY)

Days since last call: DATEDIFF([Last Order Date],[Today],DAY)

Breaking the measures into their components to test in the table, I found that:

-I'm able to pull in last call date and last order date together with Customer Number and Customer Name 

-I am not able to pull in the Today measure together with Customer Number and Customer Name 

The Today measure is defined as: TODAY()

It seems like the problem has to do with the Today measure, the DATEDIFF() function, and/or the combination of both.

Any ideas?

[v-diye-msft]

Hi @johna123 

Would you mind sharing your dummy pbix file here that we can check it further?

[jdbuchanan71]

Hello @johna123 

Very odd, just something to try maybe.  Put the TODAY() in the measures rather than as another measure?

Days since last order: DATEDIFF([last call date],TODAY(),DAY)

Days since last call: DATEDIFF([Last Order Date],TODAY(),DAY)

[johna123]

Thanks for the suggestion @jdbuchanan71 . I tried it and am still experiencing the same issue.