Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
First I want to tackle the issue as to why one table is accepting a DAX formula while the other isn't despite all the qualifiers being essntially the same (date marked as date in model, FY is text, etc.).
This DAX works to create a FY column in my Program Dollars Table:
The error I get is: "Cannot convert value " of Text to Type Number"
The whole reason I am doing this is because my Calendar table does not seem to have a relationship with Program Dollars. When I try to use the Calendar as a filter for Viz that include Program Dollars, the visuals become blank. I had a colleague build this model for me since he was more familiar with the databases involved. If you can think of a way to improve my model please let me know:
@bw70316
Value(Format('Program_Dollars'[Last_Updated],"YY")
You use format() turn the [Last_updated] column into text and then use value() to convert it to numbers. The problem is you cannot convert it in the Income table.
I wonder what are the data type for the [Last_updated] columns in the two tables, are they the same?
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I removed the blanks from the income table last updated column and the FY worked.
If anybody is willing to take on the challenge of my model so that I can filter through income and program dollars based on the calendar FY (If possible with the way the data is structured) I would greatly appreciate it.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |