Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |