IF value exists on calendar date
Hi everyone, i need help creating a measure that evaluates whether a value in on table exists at a particular date within the calender table . I am working with Two tables, on main table that has a customer and a purchase date. The second table is just a table showing the daily calendar dates. the outcome wanted is to evaluate whether a purchase was made by a customer at a certain date on the daily calender. the tables are as shown below : RESULT If a customer has purchased something on the date equivalent to the calendar date, return true, else false. as shown below: If anyone could assist me with writing a measure that could produce this outcome that would be wonderful 🙂 all help and sugegestions are welcome: Thank you
Is this a bug or something? (Using IF, HASONEVALUE and BLANK functions)
I have a measure formula like this: IF(HASONEVALUE([column_name]) , SUM([other_column_name]) , BLANK() ), so it should give the sum of the other column when the current context is one row and give blank when the current context includes more than one row. Though, when I add this measure to a visual, it doesn't allow me to include this measure in values. If I change "BLANK()" for 0 or 1, it plots the measure values without any problem. Why could this happen?Weekly aggregations not picking up appropriate data when blending data form two sources.
I have two tables that have similar information. One is an automatically generated statistical table and the other is manually refreshed from the general ledger. Periodically we need to “true up” data with the general ledger data. I have written an if statement that mostly gets the job done. The issue is that the weekly aggregations do not pick up the statistical data in the if statement.
