Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @johna123
Would you mind sharing your dummy pbix file here that we can check it further?
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)
Thanks for the suggestion @jdbuchanan71 . I tried it and am still experiencing the same issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |