need to create a report to get the daily attrited Members based on the previous month data
I am new to power Bi, where i need to create a report for daily attrited members based on the previous month data. I daily snapshot dates, new members acquired each snapshot date. I need to calculate last month member as of last month. here is the logic i need to get. Last month members using the last month snapshot date. daily net = total members - last month members closed = new members - daily net, i have atatched the data for reference, can you please help.
Running Balance and Adding Previous Month Balance
I have calculated my running balance: if balance between available and scheduled is less than 0, than 0 otherwise the difference of available to scheduled - we can't carry over a positve balance. If you don't use it you lose it. My problem is that I then need adjusted scheduled hours to be scheduled hours + -running balance from previous month. You can see in my formula I used CALCULATE('Scheduled Hours Report'[Running Balance],PREVIOUSMONTH('Date'[Date])) but it's not pulling my running balance from the previous month. Is this because my running balance is from two different tables linked by date? If so, how do I get an adjusted scheduled hours column based on any negative difference between available and scheduled hours.
Previous Month Sales with Month Selected in Slicer
Hi All, I got stuck with a DAX measure. I need to calculate the Current Month's sales and the Previous Month's sales. Both the measures are working perfectly if nothing is selected in the date or month slicer. when I select a month in the slicer then the Previous Month's sales measure is giving a blank. For example, if I select "June" in the slicer table then the Current Month's sales measure should be of June and the Previous Month's sales measure should be of May. My measure are given below: Current Month Sales = TOTALMTD ( SUM ( 'Dataset supply chain'[total sale] ), DATESMTD ( 'Dataset supply chain'[Order date] )) Previous Month Sales = CALCULATE ( SUM ( 'Dataset supply chain'[total sale] ), PREVIOUSMONTH ( DATESMTD ( 'Dataset supply chain'[Order date] ) )) I am also attaching screenshots of the results. Looking forward to a solution. Thanks, Sid
Difference from previous period (in YYYYMM format)
Hello, I have a column named PERIOD (in YYYYMM) format in both the fact and calendar tables. Is there a way to calculate the difference between current period and previous period in the pivot? Please see the screenshot below: Difference between 201902 and 201901 should be 156,276 - 258,244 = (101968) and so on. I want to show the actual values and difference in columns (pivoted format). Thanks in advance!
