Forum Discussion
Need help
Thank you very much Marcel
I need one more help. There are two tables . i want to do lookup to get the values from other table .
Need formula for lookup with condition.
I tried this = Lookupvalue(result column name, search column name, search value ) but here i want to put condition,
Is it possible.?
Doesn;t look like (standard) Power Query to me, so I don't think I can help you.
If it isPower Query, then I need more clarification, because I don't understand exactly what you are looking for.
Otherwise I would advise to raise a new topic with a descriptive title (not "Need Help"), something like "How to perform a conditonal lookup in DAX".
This one will list the name of files and created date. from this, I want to subtract 1 from date created . but i cannot change this even to date (data type) also. when i am subtracting it is giving error
In Data also, Date created is showing empty.
Hi kalpana,
you can make a new column of "Date" type which will have the substracted date; via the following:
New Column = [Date Created] - 1
See if this meets your requirement.
For data type conversion on your coulmn "Date Created", check out the following links:
- https://community.powerbi.com/t5/Integrations-with-Files-and/Date-Display-Formats/td-p/2145
- https://msdn.microsoft.com/en-us/library/mt253512.aspx
Hope it helps.
i tried this formula only i am getting error
Hi kalpana,
You want to subtract 1 day from date created, right? If it is, please try the following formula and check if it works fine.
New Column = DATE(YEAR([Date Created]),MONTH([Date Created]),(DAY([Date Created]) - 1))
Best Regards,
AngeliaI Checked it, it s not working fine. i am getting error that date is not recognized
