help
2 TopicsYear over Year Data Comparison
Hi There , Hope you doing well, I want to create an measure showing Year to Year Total sales in column chart however i want that calculation to pick automatically upcoming year data also e.g 2017,2018,2019,2020 and so on... I am using this Dax: Sales LY=calculate(Total[Sales],dateadd(dates(date),-1,Year)) but by this process i have to make each year measure ...So is there any formula where i can use single measure and all the years data will appear in one go I really appreicate if anyone can help me in this. Regards, AshishSolved1.9KViews1like4CommentsOpen Connection Error - Power Bi Embedded
Dear gents, i have created a new workspace for power bi embedded on D365 fo , and deployed it on live environment, once opening the form this error appears : "OpenConnectionError", i read a lot of this error on community but i didn't find the exact solution noting that i have 2 reports on my power bi service workspace one including row level security, at first the report with row level security was giving this error, but now both reports are returning the same error. kindly assist if there is any solution to fix it, regards,914Views0likes0Comments